topic Re: I'd like to sort 'date' and make item a group. in SAS Programming

I'd like to sort 'date' and make item a group.

kokodenden52 — Sun, 09 Sep 2018 15:15:50 GMT

I'd like to write the program below

date item sale

18/9/1 A 1,000

18/9/1 B 2,000

18/9/1 C 3,000

18/9/2 A 2,000

18/9/2 C 4,000

18/9/3 A 1,000

18/9/3 B 2,500

18/9/3 C 4,100

I'd like to sort 'date' and make item a group.

Please teach me.

PaigeMiller — Sun, 09 Sep 2018 16:20:31 GMT

It would appear that your data is already sorted by date.

I don't know what you mean by "make item a group".

PGStats — Sun, 09 Sep 2018 18:46:30 GMT

If you would like to sort by date within each item group, sort by item, then date:

proc sort data=myData; by item date; run;