DATA Step, Macro, Functions and more

SAS EG Sort Summary Table by Analysis Variable

Reply
Occasional Contributor
Posts: 17

SAS EG Sort Summary Table by Analysis Variable

I have created a summary table in SAS EG. I have it formatted and it looks exactly as I want it. The only thing left I need to do, is sort the classification variables by one of the analysis variables.

 

For example, I have Clasicication variable = People and Analysis Variable = Wage. I want to sort my table by wage largest to smallest (this is a simplified example.)

PROC Star
Posts: 554

Re: SAS EG Sort Summary Table by Analysis Variable

Use PROC SORT?

 

proc sort data = YourTableNameHere;
	by descending Wage;
run;
Super User
Posts: 17,963

Re: SAS EG Sort Summary Table by Analysis Variable

Look at the code, is it proc summary or proc tabulate?

Ask a Question
Discussion stats
  • 2 replies
  • 53 views
  • 0 likes
  • 3 in conversation