BookmarkSubscribeRSS Feed
Ronein
Onyx | Level 15

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;
1 REPLY 1
ed_sas_member
Meteorite | Level 14

Hi @Ronein 

Like this ?

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

or

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

 

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 638 views
  • 0 likes
  • 2 in conversation