PROC FORMAT to control order of the output

GreggB — Fri, 04 Jun 2021 18:25:08 GMT

issue: i'm trying to use PROC FORMAT to control the order of the TABULATE output.

output I have:

2 - Approaches	1 - Does Not Meet	4 - Exceeds	3 - Meets

what I want:

1 - Does Not Meet	2 - Approaches		3 - Meets	4 - Exceeds

my code:

proc format;
value $scr_lev
'Does Not Meet' = '1 - Does Not Meet'
'Approaches'= '2 - Approaches'
'Meets' = '3 - Meets'
'Exceeds' = '4 - Exceeds';
run;

proc tabulate data=math3;
class grade schlevel;
class performance_level;
tables grade all='TOTAL', 
performance_level*(pctn<performance_level>='PCT'*f=6.1) 
all='TOTAL'*(n*f=6.0)/rts=25 misstext='0' printmiss;
format performance_level $scr_lev. ;
run;

sample data:

grade schlevel performance_level

3 ELEM Does Not Meet

4 ELEM Meets

5 ELEM Approaches

6 MIDD Exceeds

7 MIDD Meets

8 MIDD Does Not Meet

Re: PROC FORMAT to control order of the output

ballardw — Fri, 04 Jun 2021 18:56:34 GMT

Try

class performance_level / order=formatted;

topic Re: PROC FORMAT to control order of the output in SAS Programming

PROC FORMAT to control order of the output

Re: PROC FORMAT to control order of the output