在网上看的帖子https://wenku.baidu.com/view/28c5bb6b866fb84ae55c8d29.html
按着步骤写的 但是在SAS上运行后结果无显示 而且编辑栏代码就都是绿色的
更改后的代码如下 有没有大神来解释一下,写论文必须要用面板数据做偏最小二乘 在处理数据的时候就跑不出结果了。。。。
求求求!!!!
%macro pool;/*
%do i=1 %to 12;
proc import out=d&i datafile='C:\Users\Lenovo\Desktop\sas shuju.xlsx'dbms=excel2010 place;
getnames=yes;
sheet="d&i";
run;
%end;
%mend;
%pool;
%let d1=d1;
%let d2=d2;
%let d3=d3;
%let d4=d4;
%let d5=d5;
%let d6=d6;
%let d7=d7;
%let d8=d8;
%let d9=d9;
%let d10=d10;
%let d11=d11;
%let d12=d12;
%let c1=SUR;
%let c2=LNP;
%let c3=ROI;
%let c4=DL;
%let c5=VLC;
%let c6=UR;
%let c7=PCDI;
%let c8=PCCE;
%let c9=SCI;
%let c10=CPI;
%let c11=SR;
%let c12=LR;
%marco pool1;
%do i=2 %to 7;
%do j=1 %to 12;
data &&c&j;set &&d&j;rename f&i=&&c&j;keep place f&i;
proc sort data=&&c&j;by place;run;
%end;
data pool&i merge &c1 &c2 &c3 &c4 &c5 &c6 &c7 &c8 &c9 &c10 &c11 &c12;by place;
data pool&i;set pool&i;200&i-1;run;
%end;
data pool;set pool2 pool3 pool4 pool5 pool6 pool7 pool8 pool9 pool10 pool11 pool12;
proc sort data=pool;by place year;
data pool;set pool;label &c1="SUR" &c2="LNP" &c3="ROI" &c4="DL" &c5="VLC" &c6="UR" &c7="PCDI" &c8="PCCE" &c9="SCI" &c10="CPI" &c11="SR" &c12="LR";
run;
%mend;
%pool1;
proc export data=pool outfile='C:\Users\Lenovo\Desktop\pool.xlsx' dbms=excel2010 place;
run;