topic Re: Question on SAS certification practice test in SAS Certification

Question on SAS certification practice test

stippur — Fri, 26 Jun 2020 22:01:25 GMT

Write a SAS program that will:

Create output data set results.output27a as a subset of cert.input27 where the country variable's value is “US” (any variation of case, such as US or us).
Sort results.output27a:
- first by the variable state in ascending order
- then by Postal_Code in descending order
- and finally by employee_ID in ascending order.

They are asking what employee_ID is for obs 100? They have answer as 120781. I am getting answer as 121030. Can someone please help me? Thanks. I am prepping for the exam.

Re: Question on SAS certification practice test

Mark2010 — Fri, 26 Jun 2020 22:06:35 GMT

the practice test posts example solution code in addition to the answer. What is different between that code and your code ?

Re: Question on SAS certification practice test

stippur — Fri, 26 Jun 2020 22:22:17 GMT

I am not seeing a difference between my code and what was given. I will have another look. Thanks.

Re: Question on SAS certification practice test

ballardw — Fri, 26 Jun 2020 22:40:01 GMT

Show your code.

Re: Question on SAS certification practice test

ed_sas_member — Sat, 27 Jun 2020 09:56:24 GMT

Hi @stippur

Did you put :

- a where clause on upcase(country) = "US" to be sure to retrieve "US", "Us" and "us" values?

- the following by statement: by state descending Postal_code employee_ID;

Best,

Re: Question on SAS certification practice test

stippur — Sat, 27 Jun 2020 15:45:30 GMT

Thank you for your help. I did put in the upcase stmt correctly along with the sort stmt.

Re: Question on SAS certification practice test

ballardw — Sun, 28 Jun 2020 23:42:43 GMT

I repeat

Show your code. Otherwise we have to guess line by possible line what you might have gotten wrong

And it would be best to show from the log along with any notes.

Copy the log with the code and notes and paste into a code box opened on the forum with the </> icon to preserver formatting.

That will confirm what was actually submitted. We get "code" all the time that eventually turns out not to be what was actually submitted or not paying attention to warnings and even errors.

Re: Question on SAS certification practice test

stippur — Mon, 29 Jun 2020 03:53:02 GMT

Thanks I was able to figure out the issue.