Help using Base SAS procedures

Sorting columns individually

Reply
Super Contributor
Posts: 259

Sorting columns individually


Can you sort a field in a dataset without affecting the order of other fields. Or can you sort multiple fields of a data set independently from each other?

Respected Advisor
Posts: 3,124

Re: Sorting columns individually

You can't, but you can cheat. But Why?

proc sort data=sashelp.class out=temp(keep=age);

     by age;

run;

data want;

     set sashelp.class;

     set temp;

run;

'class' was sorted by 'name', now the 'age' is also sorted . 

Super User
Posts: 3,112

Re: Sorting columns individually

Sorting usually describes changing the order of data rows.

If I understand your questions correctly, they are about changing the order columns/fields within a table - please confirm. If you want to change the order of a field where would you want to place it? First? Last? The 10th field?

An example of what you want would be useful.

Super User
Posts: 5,085

Re: Sorting columns individually

Sorting in SAS usually refers to changing the order of the rows.  The entire row moves as a unit.  However ...

If you are interested in changing the values of some of the fields within a single row, you can do that without affecting other fields within the same row:

data want;

set have;

call sortn (hand1, hand2, flop1, flop2, flop3, river, turn);

run;

Use SORTN if  your variables are numeric, or use SORTC if your variables are character.

Super Contributor
Posts: 259

Re: Sorting columns individually

Thank you

Ask a Question
Discussion stats
  • 4 replies
  • 412 views
  • 1 like
  • 4 in conversation