topic Re: Struggling with sorting in sas. in Statistical Procedures

Struggling with sorting in sas.

Nupur20 — Thu, 09 Feb 2012 22:35:39 GMT

Hi I have a dataset in sas like this:

ColA ColB ColC

Red 6 10

Blue 5 24

Average 4 5

Orange 4 10

Purple 4 11

I have to sort this data by colB in a way that "average" would be the last row like this. If I do this in usual way using "proc sort by colB" procedure, the average remains at the same place.

ColA ColB ColC

Red 6 10

Blue 5 24

Orange 4 10

Purple 4 11

Average 4 5

I would appreciate your help and suugestions and regarding the same.

Thanks.

Re: Struggling with sorting in sas.

Linlin — Thu, 09 Feb 2012 22:43:53 GMT

Hi,

I modified my code after I saw Tom's code. Thank you Tom! I have learned a lot from you.

data have;

input ColA $ : ColB : ColC;

cards;

Red 6 10

Blue 5 24

Average 4 5

Orange 4 10

Purple 4 11

;

data temp;

set have;

if upcase(ColA)='AVERAGE' then group=2;

else group=1;

proc sort data=temp out=want(drop=group);

by descending colb group;

run;

proc print;run;

Obs ColA ColB ColC

1 Red 6 10

2 Blue 5 24

3 Orange 4 10

4 Purple 4 11

5 Average 4 5

Linlin

Struggling with sorting in sas.

Tom — Thu, 09 Feb 2012 23:15:48 GMT

You probably want to create another variable to allow the average to be in its own group.

if colA='average' then group=2;

else group=1;

....

proc sort;

by group colA ....