PROC SORT AND WHERE

[Rogerio_Alves]

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

Tks!

[ballardw · Accepted solution]

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.

[Rogerio_Alves]

Tks a lot to answer!