Create an Other Category automatically within PROC FREQ

SAS_create_format_other_freq.sas

/*This is an example of how to create an Other category for everything except the top 3*/
*not ideal, other becomes first format - will look into how to make it last value;

*get counts;
proc freq data=sashelp.class order = freq;
table age / out=counts;
run;

*create format;
data counts_fmt;
set counts (OBS=3) end=eof;
*length label $10.;

fmtname = 'Age_fmt';
start = age;
label = age;

output;
if eof then do;
hlo = 'O';
label = 'Other';
output;
end;

run;


proc format cntlin=counts_fmt;
run;

*test applied format;
proc freq data=sashelp.class;
table age;
format age age_fmt.;
run;