topic Re: SAS Certification Question in New SAS User

SAS Certification Question

Alass006 — Mon, 12 Nov 2018 21:58:07 GMT

Hello folks,

I have a SAS question. Please see the attached files. It is said that the answer is A but I want to believe that is is B, because program 3 needs a proc sort before it works. Any inputs?

Thanks and regards,

Re: SAS Certification Question

Reeza — Mon, 12 Nov 2018 22:11:39 GMT

1. Learn how to make fake data and test this
2. Post your pictures directly into the forum, attachments are a pain.
3. Program 3 will error out, not just because of the sort, but because of NO BY statement, so 3 cannot generate the correct answer.

Re: SAS Certification Question

Cynthia_sas — Mon, 12 Nov 2018 22:26:58 GMT

Also, please post the title and page number of the book that you're using. Typically, our exam questions in the Prep Guide have 3-4 unique answers. In your screen shot, it looks like B and D are the same answer. If this is our Prep Guide then we need to add this to the errata.
Cynthia

Re: SAS Certification Question

Alass006 — Tue, 13 Nov 2018 14:19:10 GMT

Thank you so much for your time and inputs. I did try to copy and paste the question into the window but it was not working. That's why I used the attachment. I believe running a fake data could also be helpful.

Regards,

Re: SAS Certification Question

Cynthia_sas — Tue, 13 Nov 2018 15:16:51 GMT

Hi:

You did not say where you found the question. Was it in the Certification Prep Guide that we publish? If so, was it in the 4th edition or the 5th edition?

To make the data, so you can figure out the correct answer yourself, all you need is a DATA step program and the patience to make the datalines for input, as shown below:

data work.orders;
infile datalines dlm=',';
input Order_Date : mmddyy. Customer_ID $ Order_Total;
return;
datalines;
01/01/2011,B4523,52.30
01/02/2011,A2356,104.20
01/03/2011,C3467,27.40
01/04/2011,B4523,260.40
01/05/2011,A2356,74.54
;
run;

Then, once you have WORK.ORDERS, you can type and submit all 3 programs to see which ones work or don't work and why. If you are studying in the Certification Prep Guide, you should find a section that discusses using DATALINES as one method of creating a SAS table.

Cynthia

Re: SAS Certification Question

Alass006 — Tue, 13 Nov 2018 15:49:10 GMT

Thanks Cynthia, I found it on exam collection.
I will try to run the data you provided using the 3 programs and see the
best options.