Hi,
I have to add labels to columns in about 100 sas tables that are in one libary.
I have one table with variables that contains
1 name of the tables
2 name of columns in these tables
3 name of labels that I shoud add
how can i do it ? i was thinking about using proc datasets and macros.
Yes (proc datasets) and no (macros).
proc sort data=column_labels;
by table_name;
run;
data _null_;
set column_labels end=done;
by table_name;
if _n_ = 1 then call execute("proc datasets library=your_lib;");
if first.table_name then call execute("modify " !! trim(table_name) !! "; attrib ");
call execute(trim(column_name) !! " label='" !! trim(label) !!"' ");
if last.table_name then call execute("; "); * ends attrib statement;
if done then call execute("quit; run;");
run;
Yes (proc datasets) and no (macros).
proc sort data=column_labels;
by table_name;
run;
data _null_;
set column_labels end=done;
by table_name;
if _n_ = 1 then call execute("proc datasets library=your_lib;");
if first.table_name then call execute("modify " !! trim(table_name) !! "; attrib ");
call execute(trim(column_name) !! " label='" !! trim(label) !!"' ");
if last.table_name then call execute("; "); * ends attrib statement;
if done then call execute("quit; run;");
run;
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.