Easily done with the %untranspose macro. e.g.:
filename ut url 'http://tiny.cc/untranspose_macro';
%include ut ;
%untranspose(data=have, out=want, by=company_name,
id=date,id_informat=monyy7.,
var=var1-var14, var_first=yes)
data want (drop=date where=(month eq 3));;
set want;
format date monyy7.;
year=year(date);
month=month(date);
run;
Art, CEO, AnalystFinder.com
... View more
