PROC SORT AND WHERE

Rogerio_Alves — Thu, 24 Sep 2020 19:42:10 GMT

Do you know how many WHERE statement can I use in a PROC SORT?

Tks!

Re: PROC SORT AND WHERE

ballardw — Thu, 24 Sep 2020 19:54:42 GMT

One simple Where. Most of the procedures will only apply the last Where statement if multiples are in the code.

WHERE ALSO adds conditions to a previous Where.

You can also use compound conditions like

Where somevar in ('this value' 'that value') and Othervar=5;

If you are going to experiment with Proc Sort you want to make sure that you use an OUT= destination data set different than the source data to prevent removing records when your logic isn't quite right.

Re: PROC SORT AND WHERE

Rogerio_Alves — Thu, 24 Sep 2020 20:29:56 GMT

Tks a lot to answer!

topic Re: PROC SORT AND WHERE in SAS Programming

PROC SORT AND WHERE

Re: PROC SORT AND WHERE

Re: PROC SORT AND WHERE