topic Re: Proc sort _ Position of variables in "BY" statement in New SAS User

Proc sort _ Position of variables in "BY" statement

AthiraThulasi — Mon, 05 Feb 2024 21:30:01 GMT

Hi,

I'm a new SAS user. Pls help me understand the difference in the following code.

In the first code - rbc and wbc written right after "BY" statement are sorted in the ascending order.

In the second code - rbc and cholesterol written after wbc is not sorted in ascending order. Why is that?

As per my understanding, variables in "BY" statement are default sorted in ascending order.

PROC SORT DATA = blood OUT = sorted_blood;
BY rbc cholesterol DESCENDING wbc;
run;

PROC SORT DATA = blood OUT = sorted_blood;
BY DESCENDING wbc rbc cholesterol;
run;

Re: Proc sort _ Position of variables in "BY" statement

Patrick — Tue, 06 Feb 2024 00:43:35 GMT

As per my understanding, variables in "BY" statement are default sorted in ascending order.

That's correct.

In the second code - rbc and cholesterol written after wbc is not sorted in ascending order. Why is that?

Your sort is: BY DESCENDING wbc rbc cholesterol;

The first level of sorting is: DESCENDING wbc

Within the same value for WBC rows then get sorted by ascending rbc and then within the same value of rbc they get sorted by ascending cholesterol.

To "see" that the sorting also works for 3rd level cholesterol you would need to find multiple rows in your source data with identical values for wbc and rbc.

If you look at your data then you'll see that it's sorted as requested.

Re: Proc sort _ Position of variables in "BY" statement

rvikram — Tue, 06 Feb 2024 01:52:20 GMT

All the by variables are sorted in ascending order by default. Variables to be sorted by descending order should be preceded by the word descending, which is what you are doing in your code.

You are sorting the whole table by:
RBC in ascending order
Then, by Cholesterol in Ascending Order.

And finally, by WBC in Descending order due to the keyword 'descending' placed before WBC.

Sort applies to variables in the order listed under BY variable. If you study the rows with identical data points, you will understand.

Second example:

Re: Proc sort _ Position of variables in "BY" statement

AthiraThulasi — Tue, 06 Feb 2024 05:12:18 GMT

Got it..
Thankyou....

Re: Proc sort _ Position of variables in "BY" statement

AthiraThulasi — Tue, 06 Feb 2024 05:14:10 GMT

Got it , I checked the identical points...
Thanks much...