Reshaping an output file

finans_sas — Thu, 11 Apr 2013 21:13:39 GMT

Dear Community Members,

I am trying to reshape my output file (attached) such that I have the layout below. I would very much appreciate your help.

Thanks

panel1 111 112 113 114 115 116

model1 param

model2 param

model3 param

model4 param

panel2 121 122 123 124 125 126

model1 param

model2 param

model3 param

model4 param

panel3 131 132 133 134 135 136

model1 param

model2 param

model3 param

model4 param

panel4 141 142 143 144 145 146

model1 param

model2 param

model3 param

model4 param

Re: Reshaping an output file

PGStats — Fri, 12 Apr 2013 01:18:00 GMT

Something like this ?

proc transpose data=sasforum.A6_output out=A6_List name=model;
by panel regid _namex_;
var model:;
run;

proc sort data=A6_list; by panel model _namex_ regid;

%macro panel(p);
proc transpose data=A6_list(where=(panel=&p)) out=want&p(drop=_name_) prefix=id_;
by model _namex_;
var col1;
id regid;
idlabel regid;
run;
title "Panel = &p";
proc print data=want&p noobs label; label model="Model"; run;
%mend panel;

%panel(1);
%panel(2);
%panel(3);
%panel(4);

topic Re: Reshaping an output file in SAS Procedures

Reshaping an output file

Re: Reshaping an output file