请教用宏改变变量名

是 否 +2 论坛币

k人 参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

将变原始量名改成 flt2_num_var_noms_1，flt2_num_var_noms_2，flt2_num_var_noms_3，以此类推。

码出以下程序，可是报错，不懂如何修正，请教大虾！

%macro chg_name();

%let m=0;

  %let dsid=%sysfunc(open(uat.develop_final3));

  %if &dsid gt 0 %then %do;

  %let nobs=%sysfunc(attrn(&dsid,nobs));

  %do i=1 %to &nobs;

             %let varnume=%sysfunc(varnum(&dsid,var2));

             %let variable=%sysfunc(getvarc(&dsid,&varnume));

%let m=%eval(&m.+1);

%put &m.;

proc datasets lib=uat nolist;

modify develop_final3;

rename&variable=flt2_num_var_noms_&m.;

quit;

%end;

%end;

  %let dsid=%sysfunc(close(&dsid));

  %end;

%mend chg_name;

%chg_name;

扫码加我 拉你入群

请注明：姓名-公司-职位

以便审核进群资格，未注明则拒绝

分享0 收藏0 回帖

关键词：Variable datasets sysfunc Develop dataset

My guess: you cannot modify uat.develop_final3 in proc datasets while it's been opened in the macro already.

Changed a few places, including using  nvars, varname, and data-step rename

data class;
    set sashelp.class;
run;

%macro chg_name();
  %let dsid=%sysfunc(open(class));
  %if &dsid gt 0 %then %do;
       %let n_vars=%sysfunc(attrn(&dsid,nvars));
       %do i=1 %to &n_vars;
          %let var&i=%sysfunc(varname(&dsid, &i));
       %end;
  %end;
  %let dsid=%sysfunc(close(&dsid));
       %do i = 1 %to &n_vars;
           data class;
           set class;
           rename &&var&i=flt2_num_var_noms_&i;
           run;
       %end;
%mend chg_name;
%chg_name;

proc contents and datasets 都是效率好的过程。原因是不读取具体的数据值。虽然我见过有人有PROC CONTENTS DATA =A(OBS =1)等等的写法，但我认为这很可能是多余的。当然是个人观点。京剧

1. %let dset=uat.develop_final3;
   
2. proc contents data =&dset. varnum out=_contents noprint;
   
3. proc sql noprint;
   
4.   select cats(name,'=flt2_num_var_noms_', varnum) into :names separated by ' ' from _contents;
   
5. proc datasets lib =%scan(&dset,1) nolist;
   
6.   modify %scan(&dset,2);
   
7.   rename &names.;
   
8. run;quit;

复制代码

yongyitian 发表于 2013-5-11 09:11
Changed a few places, including using  nvars, varname, and data-step rename

data class;

no offense but try to avoid loops in macro if possible

1. proc contents data=sashelp.class out=hell(keep=name varnum) varnum;
   
2. proc sql noprint;
   
3.         select cats(name, '=flt2_num_var_noms_', varnum) into :helllist separated by ' '
   
4.         from hell
   
5.         order by varnum;
   
6. quit;
   
7. 
   
8. proc datasets library=sashelp nolist;
   
9.         modify class;
   
10.         rename &helllist;
    
11. quit;

复制代码

Agree with upper floors that using proc contents and proc datasets are the accepted methods for renaming dataset variables.