Click on the Comments to view the Answers

Wednesday, January 27, 2010

Q17

The SAS data set EMPLOYEE_INFO is listed below:

IDNumber Expenses
2542 100.00
3612 133.15
2198 234.34
2198 111.12

The following SAS program is submitted:

proc sort data = employee_info;

run;

Which one of the following BY statements completes the program and sorts the data sequentially by descending expense values within each descending IDNUMBER value?

A. by descending IDNumber Expenses;
B. by (IDNumber Expenses) descending;
C. by IDNumber descending Expenses descending;
D. by descending IDNumber descending Expenses;

5 comments:

SASGuru said...

Answer: D

You need by descending IDNumber descending Expenses;

Try it…
data EMPLOYEE_INFO;
input IDNumber Expenses;
cards;
2542 100.00
3612 133.15
2198 234.34
2198 111.12
;
run;

proc sort data=EMPLOYEE_INFO;
by descending IDNumber descending Expenses;
run;

IDNumber Expenses
3612 133.15
2542 100
2198 234.34
2198 111.12

Rujuta........ said...

D. by descending IDNumber descending Expenses;

Ryan Lo said...

Answer is D.

Please see SASGuru's comment.

And, keep in mind the keyword 'DESCENDING' appears before data set variable.

kinnari said...

Answer is D

Gaurav said...

D

Post a Comment



Technology Top Blogs On our way to 1,000,000 rss feeds - millionrss.com Hihera.com Blog Directory - OnToplist.com blogarama - the blog directory Blog Directory
Disclaimer

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.

Other brand and product names are trademarks of their respective companies.

This blog is not responsible for any kind of copyright violation. This blog just collects the links hosted or posted by other servers/people/search engines.The creator of this page or the ISP(s) hosting any content on this site take no responsibility for the way you use the information provided on this site.If anybody has any copyright claim on it and doesn’t wish the information provided to be shown on our site, please do respond to this email. We shall remove them off immediately. Any inconvenience is regretted. Please do mention your exact grievance/problems with respect to certain third party links. We assure you that appropriate action will be taken off. Thank you