Creating multiple tables from a larger dataset

[mhoward2]

This is a great write up, helps illustrate the concept well, thanks for sharing!!!!

[Ksharp]

The most efficient way is using IF-ELSE in a data step,once for all, no need PROC SORT firstly.

data have;
input color $ val;
datalines;
Green 5
Green 8
Green 3
Green 1
Green 10
Yellow 9
Yellow 2
Yellow 6
Yellow 8
Yellow 12
Yellow 5
Yellow 8
Purple 5
Purple 2
Purple 6
;
proc freq data=have noprint;
table color/out=color nopercent nocum;
run;
data _null_;
if _n_=1 then do;
 call execute('data ');
 do until(last);
   set color end=last;
   call execute(color);
 end;
 call execute(';set have; select(color);');
end;
set color end=eof;
call execute(cat('when("',color,'") output ',color,';'));
if eof then call execute('otherwise;end;run;');
run;