Hell to all, In order to keep record of the source of the variables when merging multiple data sets together, I would like to add the data set name to the original variable labels. For example: variable name : income, which is in data set "W2" original label: total income desired label: total income W2 Put it in another way, I would like to add the words of data set name to all the variables in a data set. The following is the codes that I have come up. The codes do not change the labels. I wonder if anyone could give me some suggestion how to revise the codes or any better idea to do this task? Thank you! *--------------------------------------------; data _null_; call execute("data &syslast.; set &syslast. end=eof;"); call execute('array abc{*} _character_;'); call execute('array def{*} _numeric_;'); call execute('do i=1 to dim(abc);'); if eof then call execute('label abc{i}='||'"'strip(vlabel(abc{i}))||'&syslast";'); call execute('end;'); call execute(`do j=1 to dim(def);'); if eof then call execute(`label def{j}='||'"'strip(vlabel(def{j}))||'&syslast";'); call execute('end:'); call execute('run;'); *--------------------------------------;
... View more