- /*取出r3所有变量名和标签并排序,赋给宏变量varname、varlabel*/
- proc sql noprint;
- select name,varnum,case when label='' then compress("'"||name||"'") else compress("'"||label||"'") end
- into :varname separated by ' ' ,:varorder,:varlabel separated by ''
- from dictionary.columns
- where memname='R3'
- order by varnum;
- quit;
- options noxwait noxsync;
- x '"D:\输出.xlsx"';
- /*data _null_; x=sleep(3); run;*/
- filename result dde 'excel|输出!r1c2:r100c50' notab;
- data _null_;
- set r3;
- file result dlm='09'x;
- if _n_=1 then put &varlabel.;
- put &varname.;
- run;
if _n_=1 then put ???????; 这里,想在第一行写变量标签/变量名,怎么写?