topic Labeling multiple variables in SAS Programming

Labeling multiple variables

petlove — Thu, 26 Jul 2018 15:56:20 GMT

Hi all,

I am trying to label all variables to new label which will have variable name and its label.

e.g. Current label of AETERM is "Reported Term for the Adverse Event". I am trying to re-label it to "AETERM Reported Term for the Adverse Event".

can we do this by call execute?

Thank you.

Re: Labeling multiple variables

PeterClemmensen — Thu, 26 Jul 2018 16:01:51 GMT

I think you are looking for something like in this example

http://support.sas.com/kb/24/664.html

Re: Labeling multiple variables

Reeza — Thu, 26 Jul 2018 16:10:16 GMT

@petlove wrote:

Hi all,

I am trying to label all variables to new label which will have variable name and its label.

e.g. Current label of AETERM is "Reported Term for the Adverse Event". I am trying to re-label it to "AETERM Reported Term for the Adverse Event".

can we do this by call execute?

Thank you.

Yes you can, use PROC DATASETS and feed the labels in.

*Create label data set;
data label_data_set;
length name label $25.;
name="Sex"; label="Gender"; output;
name="height"; label="Height (in)"; output;
name="weight"; label="Weight (lbs)"; output;
run;
 
 
*Create sample dataset to apply label;
data class;
set sashelp.class;
run;
 
 
*Create macro variable that holds label statement;
proc sql noprint;
select catx("=", name, quote(trim(label)))
  into :label_list separated by " "
from label_data_set;
quit;
 
 
*Display macro variable in log;
%put &label_list.;
 
 
*Apply labels without recreating dataset;
proc datasets library=work;
modify class;
label &label_list.;
run;quit;
 
 
*Print the dataset to display new labels;
proc print data=class label noobs;
run;

Re: Labeling multiple variables

petlove — Thu, 26 Jul 2018 16:24:33 GMT

Thank you Reeza...