which one is correct ?

tianerhu — Mon, 06 Mar 2023 14:49:46 GMT

proc sort data = sydney.demo out = PSORT;
  by age descending height weight;
run;

/* which statement is true regarding the submitted program? 
A.The descending option applies to the variable height.
B.The variable CODE is sorted by ascending order.
C.The PSORT data set is sorted in the SASUSER library.
D.The descending option applies to the DATE and COST variables.
*/

proc sort data = sydney.demo out = PSORT;
  by age descending height weight;
run;

/* which statement is true regarding the submitted program? 
A.The descending option applies to the variable height.
B.The variable CODE is sorted by ascending order.
C.The PSORT data set is sorted in the SASUSER library.
D.The descending option applies to the DATE and COST variables.
*/

proc sort data = sydney.demo out = PSORT;
  by age descending height weight;
run;

/* which statement is true regarding the submitted program? 
A.The descending option applies to the variable height.
B.The variable CODE is sorted by ascending order.
C.The PSORT data set is sorted in the SASUSER library.
D.The descending option applies to the DATE and COST variables.
*/

The following SAS program is submitted:

proc sort data = SASUSER.VISIT out = PSORT;

by code descending date cost;

run;

which statement is true regarding the submitted program?

A. The descending option applies to the variable CODE.

B. The variable CODE is sorted by ascending order.

C. The PSORT data set is stored in the SASUSER library.

D. The descending option applies to the DATE and COST variables.

Thank you for your help.

Re: which one is correct ?

maguiremq — Mon, 06 Mar 2023 14:55:37 GMT

Hi @tianerhu, what are you thinking so far?

Re: which one is correct ?

tianerhu — Mon, 06 Mar 2023 15:36:17 GMT

i didn't understand what is descending correctly.
and now, I think that I have solved it and just want to make sure.

Re: which one is correct ?

tianerhu — Mon, 06 Mar 2023 15:38:44 GMT

the answer is B .

Re: which one is correct ?

maguiremq — Mon, 06 Mar 2023 15:39:17 GMT

So, descending in PROC SORT sorts the variable that comes after it and only it. Otherwise, everything else is sorted ascending if it doesn't have descending specified. I think it is B iirc.

Re: which one is correct ?

tianerhu — Mon, 06 Mar 2023 15:47:21 GMT

Thank you for your help.

topic Re: which one is correct ? in SAS Programming

which one is correct ?

Re: which one is correct ?

Re: which one is correct ?

Re: which one is correct ?

Re: which one is correct ?

Re: which one is correct ?