The contents of the raw data file CALENDAR are listed below:
--------10-------20-------30
01012000
The following SAS program is submitted:
data test;
infile 'calendar';
input @1 date mmddyy10.;
if date = '01012000'd then event = 'January 1st';
run;
Which one of the following is the value of the EVENT variable?
A. 01012000
B. January 1st
C. . (missing numeric value)
D. The value can not be determined as the program fails to execute due to errors.Click Comment link to get answer
The answer is D
ReplyDeleteAnswer is D, will not execute because of errors.
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteanswer D
ReplyDeleteAnswer D is becaues date constant is invalid. [Evern after providing correct date constant -date='01JAN2000'd desired output not produced and it produces Note: SAS went to a new line when INPUT statement reached past the end of a line.]
ReplyDeleteShiva,
ReplyDeleteThe error thats shown even on your correction is probably because the informat given is wrong. The informat should be 'mmddyy8.'. Once u do that, the event shows up as January 1st
Good explanation
DeleteAnswer is D. If we provide correct date contant date='01jan2000'd, will get the result.
ReplyDeleteplease try the below program.
data test;
infile datalines;
input @1 date mmddyy10.;
if date = '01jan2000'd then event = 'January 1st';
datalines;
01012000
;
sweta....try i twith date='01012000' and still u get the result , tha answer should be b
ReplyDeleteThe answer should be B. try this program:
ReplyDeletedata test;
infile datalines;
input @1 date mmddyy8.;
if date = '01012000'd then event = 'January 1st';
datalines;
01012000
;
proc print;
run;
Sadly, your program is not working! Answer is D
DeleteAnswer is D. because question mentions date constant ( Notice d). Not just '01012000'.
ReplyDeleteans is D that because 01012000 is changed to its default sas date so when we assign '01012000'd it take it as invalid format...
ReplyDeletethe answer should be B.
ReplyDeleteTry this,
data test;
infile 'calendar';
input @1 date mmddyy10.;
if date = '01012000'd then event = 'January 1st';
proc print;run;
No,the ans is d
DeleteThere are 0 observations in the output BECAUSE the date format that is specified is wrong.
it should be
if date="01jan1960" then event="january 1st";
try this
answer is D.
ReplyDeleteSyntax error due to incorrect format fails to execute "D" finals answer.
ReplyDeleteSakar Sham
But in the log it does not say syntax error?
ReplyDeleteAniket , your are right if we take the d out from the statement then it will give this;
obs date event
1 14610
that d is the culprit for error!
No, d is not the error, the problem is because of '01012000', if you change '01012000'd to '01JAN2000'd, the problem would be fixed.
Deletedata test6;
ReplyDeleteinfile 'FILENAME';
input @1 date mmddyy8.;
if date = '01012000' then event = 'January 1st';
run;
Output: 14610 - runs without error but not what we want.
data test6;
infile 'FILENAME';
input @1 date $; *or numeric input @1 date;
if date = '01012000' then event = 'January 1st';
run;
Output: date = 01012000 and event = January 1st
Both of the above run without errors.
answer is B
ReplyDeleteAnswer is B, run the below code, you will get correct answer
ReplyDeletedata test;
input @1 date mmddyy10.;
if date = '01012000'd then event = 'January 1st';
datalines;
01012000
;
run;
proc print;
run;
Sorry Answer is D, ignore the above answer posted by me
ReplyDeletefollowing error appears in the log:
Invalid date/time/datetime constant '01012000'd.
Invalid number conversion on '01012000'd.
Karel;
ReplyDeleteIf instead of '01012000'd there was standing '01JAN2000'd, the program would have worked with event being January 1st, but with the original notation it doesn't.
--> Answer D is correct.
Try this:
data test;
infile datalines;
input @1 date mmddyy10.;
if date = '01JAN2000'd then event = 'January 1st';
datalines;
01012000
;
proc print;
run;
this is the log file error for me so answer is D
ReplyDelete51 data zak1;
52 infile "D:\Date.txt";
53 input @1 date mmddyy10.;
54 if date = '01012000'd then event = 'January 1st';
-----------
77
ERROR: Invalid date/time/datetime constant '01012000'd.
ERROR 77-185: Invalid number conversion on '01012000'd.
55 run;
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.ZAK1 may be incomplete. When this step was stopped there were 0
observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 2.16 seconds
cpu time 0.01 seconds
271 data test;
ReplyDelete272 infile "d:\sas\test.txt";
273 input date mmddyy8.;
274 if date = '01012000'd then event = 'January 1st';
-----------
77
ERROR: Invalid date/time/datetime constant '01012000'd.
ERROR 77-185: Invalid number conversion on '01012000'd.
The answer is D because '01012000'd cause the error. We know d function after the date value is to transfer the date into a sas date number. Just think it logically, for value like 01012000, if we used d or date. format to transfer it into sas date value, sas has no way to find out which is month, which is day and which is year, So if we wanted to transfer value like '01012000' into sas date value, we could only mmddyy format to tell sas who is who. So this part caused a syntax error
ReplyDeletethank you so much
DeleteD is correct.Page 173. DAte constant is 'ddmmmyy'd or 'ddmmmyyyy'd. It assigns date values to variables in assignment statements.
ReplyDeleteGM;;
ReplyDeleteD is correct.Page 173. DAte constant is 'ddmmmyy'd or 'ddmmmyyyy'd. It assigns date values to variables in assignment statements.
Call us now at OUR toll free. We are Americans #1 Free Chat Line. NO credit card is required! Call Now! FREE CHAT!!! 1-706-443-9999 (over the age of 18). Meet exciting local guys and gals! Site: www.freenitechat.com
ReplyDeleteFirst: Infile statement is wrong
ReplyDeleteSecond: mmddyyy date format is wrong..
Right ans: Infile __________;
'mmddyyy'8.
Date should be date='01jan2000'd , it will output the desired January 1st if so.
ReplyDeleteDate constant: A date constant is a date in the form of ddMMMyyyy in quotation marks followed by the character d. So, we should write it as a date constant instead of a number in the quotation mark.
Thanks Karen I needed that. I am autistic and on disability.
ReplyDeletegclub
gclub casino online
I am reading your post from the beginning, it was so interesting to read & I feel thanks to you for posting such a good blog, keep updates regularly.
ReplyDeleteSAS Online Training
Tableau Online Training|
R Programming Online Training|
I really like you post,Thanks for your sharing.
ReplyDeleteดูหนังออนไลน์
Thank you for your post. This is excellent information. It is amazing and wonderful to visit your site.
ReplyDeleteSAS Data Analytics Training with Placement Support
This blog is really helpful regarding all educational knowledge I earned. It covered a great area of subject which can assist a lot of needy people. Everything mentioned here is clear and very useful.
ReplyDeleteสล็อต scr
ReplyDeleteVery Impressive SAS Programming tutorial. The content seems to be pretty exhaustive and excellent and will definitely help in learning SAS Programming. I'm also a learner taken up SAS Tutorial and I think your content has cleared some concepts of mine. While browsing for SAS Tutorial on YouTube i found this fantastic video on SAS Programming. Do check it out if you are interested to know more.:-https://www.youtube.com/watch?v=4PtMFE4IjLg&t=456s
D
ReplyDeletePositive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work.
ReplyDeleteCredo systemz is one of the best R language training in Chennai, and We offers best R programming language training with more real time scenarios.Using this Course you learn very in-depth of R language for Data Science and Machine Learning.
R Programming institutes in Chennai | R Programming Training in Chennai
ReplyDeleteGreat post! I am actually getting ready to across this information, It's very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.big data training in Velachery | Hadoop Training in Chennai | big data Hadoop training and certification in Chennai | Big data course fees
This comment has been removed by the author.
ReplyDeleteGreat efforts put it to find the list of articles which is very useful to know, Definitely will share the same to other forums.hadoop training in chennai velachery | hadoop training course fees in chennai | Hadoop Training in Chennai Omr
ReplyDelete01012000
ReplyDeleteWhat a igcp.sas 11skype
ReplyDeletePlease tell
ReplyDelete01012000
ReplyDeleteThat is very interesting; you are a very skilled blogger. I have shared your website in my social networks! A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article.thanks keep post more content.
ReplyDeleteC and C++ Training Institute in chennai | C and C++ Training Institute in anna nagar | C and C++ Training Institute in omr | C and C++ Training Institute in porur | C and C++ Training Institute in tambaram | C and C++ Training Institute in velachery
eat post! I am actually getting ready to across this information, It's very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.
ReplyDeleteAWS training in Chennai
AWS Online Training in Chennai
AWS training in Bangalore
AWS training in Hyderabad
AWS training in Coimbatore
AWS training
พนัน 1xbet es พวกเกมส์ พนันออนไลน์บนโทรศัพท์มือถือ 1xbet ios ฝาก-ถอนไว 1XBET
ReplyDeleteพวกน่าดึงดูดอีกหมู่ของเว็บไซต์นี้เป็น 1xbet casino
เกมส์ – (game)
หมวดนี้จะเป็นหมวดของเกมส์ทั้งหมดเลยไม่ว่าจะเป็น เกมไพ่ เกมออนไลน์ เอาชีวิตรอด ท้า table games ลูกเต๋า ไต่สู่ชนะ เป่ายิ้งฉุบ อื่นๆอีกมากมาย สำหรับคอเกมส์โดยเฉพาะอย่างยิ่ง มีให้เลือกเล่นมากมายก่ายกอง ให้คอเกมส์ได้เบิกบาน ได้เต็มกำลังเว้นแต่ที่ผมยกตัวอย่างมานั้น ยังมีอีกเยอะมาก เป็นต้นว่า กีฬาเสมอเหมือนจริง โทรทัศน์เกม บิงโก numbers โตโต้ โป๊กเกอร์ ที่ทุกคนสามารถไปเลือกเล่นตามปรารถนาได้เลย
ท้ายที่สุดเป็นเว็บของพวกเรามีหนทางการติดต่อที่สะดวกแล้วก็วิธีการสมัครที่เรียกง่ายไม่ยุ่งยากมีคณะทำงานรอให้คำปรึกษาขอความเห็นรวมทั้งรอช่วยเหลือตลอด 1 วันยืนยันว่าพนันไมมีผิดหวังอย่างไม่ต้องสงสัย ยังมีค่าทดแทนรวมทั้งเชื่อมั่นในความปลอดภัยไม่ต้องรอกลุ้มใจว่าพนันออนไลน์แล้วจะถูกโกง มีรีวิวจากผู้ใช้งานจริงหลายๆคนว่ามั่นอกมั่นใจและก็ไว้ใจแน่ๆ
aşk kitapları
ReplyDeleteyoutube abone satın al
cami avizesi
cami avizeleri
avize cami
no deposit bonus forex 2021
takipçi satın al
takipçi satın al
takipçi satın al
takipcialdim.com/tiktok-takipci-satin-al/
instagram beğeni satın al
instagram beğeni satın al
btcturk
tiktok izlenme satın al
sms onay
youtube izlenme satın al
no deposit bonus forex 2021
tiktok jeton hilesi
tiktok beğeni satın al
binance
takipçi satın al
uc satın al
sms onay
sms onay
tiktok takipçi satın al
tiktok beğeni satın al
twitter takipçi satın al
trend topic satın al
youtube abone satın al
instagram beğeni satın al
tiktok beğeni satın al
twitter takipçi satın al
trend topic satın al
youtube abone satın al
takipcialdim.com/instagram-begeni-satin-al/
perde modelleri
instagram takipçi satın al
instagram takipçi satın al
takipçi satın al
instagram takipçi satın al
betboo
marsbahis
sultanbet
Slot Online
ReplyDeleteSerbu4d
Login Serbu4d
Daftar win88
pokerace99
Bola88
Net Commerce notes
ReplyDeleteaws solution architect training
ReplyDeleteazure solution architect certification
openshift certification
azure data engineer certification
Wow. It is such an amazing article. And I would like to bookmark the page so that I can come here again for you to read. What American citizen need visa for Turkey ? Yes , of course all the American Citizens need a visa to visit . Because the USA is not included in the list of those countries which do not require a visa permit to visit Turkey.
ReplyDeleteThanks for sharing this article with us... I hope you will continue in the future... The question is how much Indian visa fees are?So The Indian visa fees depend on your visa type, your nationality, and processing time. If you have any kind of doubts check about them and clear your doubts.
ReplyDeleteThanks for taking the time to talk about it; it's something I was very excited to know about. In the Computer Vision software. We provide image analysis software for a variety of businesses by combining deep learning and computer vision. If you want to take advantage of this service, go and check out the page.
ReplyDeleteçekmeköy
ReplyDeletekepez
manavgat
milas
balıkesir
FW5
bayrampaşa
ReplyDeletegüngören
hakkari
izmit
kumluca
D3QİO