Can de bug it ? (Why can not export to ecxel file after Proc Model )
Thanks!
I construct a macro program under Intheangel’s given codes,
because I have lots of “a” file : totala1(start)---->totala135(end)
lots of “d” file : totald1(start)---->totald135(end)
I hope all results of “afters” file : after1(start)---->after135(end)
------------------------------------------------------------
%macro country(cstart,cend)
%Do i=&cstart %to &cend;
procimportdatafile=”c:\temp\toatala.&i.csv”
out=a.&i
dbms=csv
replace;
getnames=no;
run;
procimportdatafile=”c:\temp\toatalb.&i.csv”
out=d.&i
dbms=csv
replace;
getnames=no;
run;
PROCMODEL DATA= a.&i ;
y=a0+a1*x;
by group;
FIT y / OUTEST=b.&i ;
SOLVE y / DATA=d.&i ESTDATA=b.&i OUT=c.&i ;
BY group;
RUN;
Data cc.&i(keep=month group y);
Merge d.&i c.&i;
by group;
run;
proctranspose data=cc.&I out=after.&i(drop=_name_);
by group;
id month;
procexport data= after&i
outfile="c:\temp\after&i.csv"
dbms=csv
replace;
run;
%end;
%mend country;