topic controlling the output order using PROC FREQ in SAS Programming

controlling the output order using PROC FREQ

GreggB — Tue, 03 Dec 2019 14:50:04 GMT

I want to control the order of output so that the last row is first, the first row is second and the second row is third.

code:

proc freq data=four;
table lre_placement / nocum;
run;

output

Inside Reg Class 40-79% of day

Inside Reg Class >80% of day

Inside Reg Class <40% of day

Jagadishkatam — Tue, 03 Dec 2019 15:05:19 GMT

Please try the below code

proc freq data=four order=internal;
table lre_placement / nocum;
run;

Jagadishkatam — Tue, 03 Dec 2019 15:09:17 GMT

Alternatively you can use the format to order

proc freq data=four order=formatted;
table lre_placement / nocum;
format lre_placement xformat.;
run;

Ksharp — Wed, 04 Dec 2019 12:01:19 GMT

Add a white blank before last row.

data four;

set four;

if lre_placement='Inside Reg Class <40% of day' then lre_placement=' Inside Reg Class <40% of day';

run;