topic Add a new column with label information in SAS Programming

Add a new column with label information

Ronein — Mon, 17 Feb 2020 09:26:10 GMT

Hello

I want to create a data set that contain information of label name for each field

The new data set will contain 2 fields:

"Field name"

"label"

data rawtbl;
input ID Sex $ height;
cards;
1 M 178 
2 M 198
3 F 156
;
Run;

data rawtbl2;
set rawtbl;
label ID='Customer ID'  Sex='Gender' height='Height';
Run;

Re: Add a new column with label information

ed_sas_member — Mon, 17 Feb 2020 09:35:13 GMT

Hi @Ronein

Like this ?

proc contents data=rawtbl2 out=metadata (keep=name label) noprint;
run;

proc sql;
	create table metadata as
	select name, label
	from dictionary.columns
	where libname = 'WORK' and upcase(memname) = 'RAWTBL2';
quit;