topic Re: Sort dataset alphabetically based on multiple variables? in New SAS User

Sort dataset alphabetically based on multiple variables?

monsterpie — Wed, 26 May 2021 17:23:31 GMT

Hello all,

I have a dataset with 5 variables and I am trying to sort my observations alphabetically across all 5 variables. Is this at all possible in SAS?

ballardw — Wed, 26 May 2021 17:34:28 GMT

Try

Proc Sort data=yourdatasetname;

by firstvar secondvar thirdvar fourthvar fifthvar;

run;

If that doesn't get the result you want then be prepared to share some data and what you expect the sorted result to look like.

Reeza — Wed, 26 May 2021 17:36:40 GMT

Depends, please show an example. I would suggest looking at CALL SORTC() most likely.