In the following SAS program, the input data files are sorted by the NAMES variable:
libname temp 'SAS-data-library';
data temp.sales;
merge temp.sales
work.receipt;
by names;
run;
Which one of the following results occurs when this program is submitted?
A. The program executes successfully and a temporary SAS data set is created.
B. The program executes successfully and a permanent SAS data set is created.
C. The program fails execution because the same SAS data set is referenced for both read and write operations.
D. The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.
Click Coment link to see answer.
The right answer is B. Both datasets sales and receipt are sorted by names variable which in turn is used to merge the two datasets. The resulting dataset is over-written on temp.sales dataset. As temp is a permanent library unlike work (which is temparory) option B is the right choice.
ReplyDeleteB
ReplyDeletecorrect answer B
ReplyDeleteB
ReplyDeleteB
ReplyDeleteB
ReplyDeleteb
ReplyDeleteVery helpful website. Thanks
ReplyDeleteCorrect Answer is B
ReplyDelete1)temp is declared as a permanent lib so permanent dataset will be craeted
2)same dataset can be read and write in a step
3)work and perm datasets can be merged
Ok, I understand this place is for commenting for the above question, but I couldn't find any good "forum" site regarding SAS base certificate preparation. so I thought maybe I can post a question that I had trouble with.
ReplyDeleteQuestion1.
The following program is submitted.
data test;
input name $ age;
cards;
John +35
;
run;
Which values are stored in the output data set?
Answer:
I thought it'd be "John" and "missing value"
anyone else?
Dear Blogger,
If theres other section where you would allow people to post questionsfor open discussion, i'd gladly post couple to question on that section.
If anyone knows a such site, please email me at
passalrighty@gmail.com
THX in advance!.
hi anonymous..
Deleteyour answer is
John 35
you can also cchek it by running this syntax in sas.
Hi! your answer is
DeleteJohn 35
Even I had the same question when I solved the sample questions on sas website. But then realised standard numeric value in sas are positive and negative numbers, scientific notations, decimal numbers. so +32 is numeric value.
Deleteoh btw, i forgot to praise this site.
ReplyDeletereally, the best website that allows people to prepare for their examination.
I really think we all owe this site a BIG TIME.
passalrighty@gmail.com
ReplyDeleteAny numbers with the sign + or - does as taken as a number , but if it comes with other special character then it does not read as number and will give you a missing value in output.
Find out what are not valid sign for number.
Did I answer you?
Posted 9/9/2012: I want to thank from the bottom of my heart the author of this blog for the effort to set this up for the benefit of fellow SAS-ers.
ReplyDeleteIt was very useful to brush through these questions apart from other material available on the Net. More useful than the Base Prep Guide from SAS! A handful of the questions were from here.
I got my Base Cert done! If there is similar blog for Advanced please post a link here.
Hey congrats on your success. I'll be appearing for test on 11 august, Please tell me If I'm able to solve all these 119 questions then how good are my chances for clearing the actual base sas test?
DeleteIs there any forum like this to prepare for the ADVANCED sas 9 certification? Thanks
ReplyDeleteThanks dude. I m certified now. Wow,,......
ReplyDeleteMany many thanks. it is great work done by you.
Hey congrats on your success. I'll be appearing for test on 11 august, Please tell me If I'm able to solve all these 119 questions then how good are my chances for clearing the actual base sas test?
Deleteis this the last question?
ReplyDeleteThis Website helped me a lot
Thank you
This comment has been removed by the author.
ReplyDeleteVery useful blog and very informative article thank you sharing keep posting sas training, sas admin training, sas clinical training,sas platformadmin training
ReplyDeleteHi, Thanks for sharing the information. These information will really help us a lot..A
ReplyDeleteHats off to your presence of mind.
ReplyDeleteI really enjoyed reading your blog. I really appreciate your information which you shared with us.
SAS Online Training
A nice article here with some useful tips for those who are not used-to comment that frequently. Thanks for this helpful information I agree with all points you have given to us. I will follow all of them.
ReplyDeleteMSBI Training in Chennai
Informatica Training in Chennai
Your website is really cool and this is a great inspiring article.
ReplyDeleteמדביר
I have the base exam in two hours.
ReplyDeleteWao, Really awesome work, So I just want to share an online converter that will support in every situation;
ReplyDeleteEasy Convert Files
You can easily create those formats;
ReplyDeleteGif to Mov
Mp4 to Ogg
3gp to mp3
Avi to Mpeg
Webm to Gifs
This Post is really supportive to all of us. Eager that these kind of information you post in future also. Thanks for Sharing Otherwise if anyone want To Learn SAS Training So You Can Visit here- https://www.htsindia.com/Courses/business-analytics/sas-training-courses
ReplyDeletesas training institute in delhi
sas training course in delhi
sas training center in delhi
it's really a piece of new information to me, I learn more from this blog, I want to learn more from this blog, keep on it doing, I eagerly waiting for your updates, Thankyou. other anyone wants to learn SAS course s contact here- +91-9311002620 or visit website- https://www.htsindia.com/Courses/business-analytics/sas-training-institute-in-delhi
ReplyDeleteInteresting Post. It is really Nice and lovely post. keep it up. keep blogging. otherwise anyone wants to learn SAS training course so, contact here- +91-9311002620 or visit website- https://www.htsindia.com/Courses/business-analytics/sas-training-institute-in-delhi
ReplyDeleteİnside Benzeri Oyunlar
ReplyDeleteFM Benzeri Oyunlar
Rigorz Benzeri Oyunlar
6E4