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;
Click Comment link to get answer
A
ReplyDeleteD
ReplyDeleteIts D
ReplyDeletesort variables.
ReplyDeleteascending is default
so
Descending Var1 Descending var2
D is the Ans
ReplyDeleteThis comment has been removed by the author.
ReplyDeleted
ReplyDeleteD
ReplyDeleteAns is D
ReplyDeleteCorrect Ans is D
ReplyDeleteFor each variable we have to mention descending keyword before variable name.
D
ReplyDeleteD
ReplyDeleteyou all wrong. its C. Refer to SAS here:
ReplyDeletehttp://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473666.htm
Nops....you are wrong....in that example TOWN is sorted in ascending by default, then within TOWN- DEBT is sorted by descending, and then within TOWN & DEBT- ACCOUNTNUMBER is sorted by ascending. However sorting of accountnumber makes no difference because every record by TOWN & DEBT is unique. Let me know if you agree
ReplyDeleteD
ReplyDeleteD
ReplyDelete