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.
It would appear that your data is already sorted by date.
I don't know what you mean by "make item a group".
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;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.