Set yourself apart with a SAS Certification credential

Certification sample question

Reply
Occasional Contributor
Posts: 19

Certification sample question

The contents of the raw data file FURNITURE are listed below:

 

--------10-------20-------30
chair,,table
chair,couch,table

The following SAS program is submitted:


data stock;
infile 'furniture' dsd;
input item1 $ item2 $ item3 $;
run;

Which one of the following is the value of the variable named ITEM2 in the second observation of the output data set?

A. table
B. ,table
C. . (missing numeric value)
D. ' ' (missing character value)

*************************************************************************************************

My answer is couch. but this not in options.

 

Can anyone tell me what is the option for this. It was a sample question and people are giving different answers.

Kindly help. Smiley Happy

Super Contributor
Posts: 395

Re: Certification sample question

Instead of just us telling you why don't you create a file as shown and then run the data step to see what you get. Then try to figure out why. You'll always learn more that way than by being simply told the answer....

Super User
Posts: 9,867

Re: Certification sample question

Maybe the question is :
named ITEM2 in the FIRST observation................


Occasional Contributor
Posts: 19

Re: Certification sample question

Respected Sir,

 

Did the same already, hence my answer was couch. But it was not in options and the comments were option A.

Just wanted to ask if I've commited some mistake anywhere.

 

data stock;
infile 'C:\Documents and Settings\Administrator\Desktop\SAS\sas.csv' dsd;
input item1 $ item2 $ item3 $;
run;

 

Did the above code and called the attached file output is : couch. Let me know if I'm wrong or the question.

Thanks.

Attachment
Super User
Posts: 9,867

Re: Certification sample question

I get the same answer as yours.




data stock;
infile cards dsd;
input item1 $ item2 $ item3 $;
cards;
chair,,table
chair,couch,table
;
run;

Super User
Posts: 19,080

Re: Certification sample question

What is the source of the question? The SAS Certification guide? If so, what page/chapter?

Occasional Contributor
Posts: 19

Re: Certification sample question

this is on the blog. Not certification guide
Community Manager
Posts: 2,889

Re: Certification sample question

I found the blog you mention.  It's not a SAS-supplied site, and the questions there are (probably) not coming from SAS materials.  If the question/answer there are incorrect, it could be a mistake -- but we don't have a way to verify the intent of that publisher or to make any correction to that material.

 

However, you can find a bevy of recent materials -- much of this for free -- from the SAS Certification site.

Super User
Posts: 19,080

Re: Certification sample question

caveat emptor. Try the SAS certification guide for some more relevant questions.

 

 

SAS Moderator
Posts: 47

Re: Certification sample question

Hello,

 

I could not agree more with Chris Hemedinger's reply to your question.  I work in the Certification group and always try to emphasize the importance of looking at the materials we provide out on our web site.  If you go to the link Chris provided in his response, you will be able to download a complete, detailed, exam objective outline.  This provides tremendous detail on what is covered on the exam.  We provide this for all of our exams.  In addition, there is a link to sample questions.  These are all FREE.  We also provide a complete practice exam that is similar in structure and difficulty level to the live exam.  There is a charge for this exam but it is not exorbitant and I believe it is a good investment as part of your complete study strategy.  Full explanations are provided for each of the exam items on the practice exam. 

 

The SAS Certification Community is sponsoring a FREE Webinar:  SAS Certification Review Session:  Base Programmer for SAS 9 this Thursday, September 14 at 11 AM ET.   It's an hour long so we cannot possibly go over everything but we are going to provide an overview of the exam topics and focus in on some areas where we have seen candidates struggle.  There will be Q&A time provided as well. 

Register Now if you'd like to attend.

Senior User
Posts: 1

Re: Certification sample question

I missed the FREE Webinar:  SAS Certification Review Session:

 

Can you tell me where can I view that? thanks

 

Helen

SAS Moderator
Posts: 47

Re: Certification sample question

Hello,

 

If you were unable to attend today's FREE webinar:  Preparing for the SAS Base Programming Certification Exam,  I will be posting a link to the On-Demand version of the webinar along with a PDF copy of the Q&A session here on the SAS Certification Community site within the next few days.  I will post an announcement on this community board.

 

Thank you for your interest in the SAS Global Certification program. 

SAS Moderator
Posts: 47

Re: Certification sample question

[ Edited ]

Hello,  

 

Early next week,  I will Post-webinar resources posted to SAS® Certification Community

 

As a reminder, the following resources will be made available in the SAS Certification Community after the live webinar event:

·        On-demand presentation link. 

·        Presentation slides. 

·         Q&A topics.

 

Senior User
Posts: 1

Re: Certification sample question

I missed it as well, please post the link!
Regular Learner
Posts: 1

Re: Certification sample question

Unfortunately due to work I missed it too. Looking forward to viewing the recordings and the PDF . Thanks
Ask a Question
Discussion stats
  • 14 replies
  • 427 views
  • 9 likes
  • 9 in conversation