topic Re: ProcSort in SAS Programming

ProcSort

harveysarah0 — Mon, 02 Mar 2020 23:28:44 GMT

Report the release dates listed for the 3 highest grossing albums in SAS’s default date

formatting.

Would you use procsort here?

Thought it might be something along these lines:

Proc sort data= Albums;
By ReleaseDate;
Run;

But I know I still need to incorporate the 3 highest grossing albums in there

Re: ProcSort

PaigeMiller — Mon, 02 Mar 2020 23:43:47 GMT

I'll give you a hint. If you ask to sort by ReleaseDate, then you learn which albums were released first, but you learn nothing about the amount of the gross revenue of the album. So, you need to sort by ......

Re: ProcSort

Reeza — Tue, 03 Mar 2020 02:14:44 GMT

You should be able to run that and see if it's the right answer. Is it giving you what you want? How would you do it in Excel?

Re: ProcSort

Patrick — Tue, 03 Mar 2020 03:11:35 GMT

Besides of Proc Sort using Proc Rank is another option which also deals with ties.