DATA Step, Macro, Functions and more

How to replace empty labels to variable name

Reply
Occasional Contributor
Posts: 7

How to replace empty labels to variable name

Hello everyone,

 

Could you please help me in replacing empty lable values with Variable names in sas dataset.

 

I have dataset with multiple variables and the corresponding label names are empty, I would like to replace all the labels to their respective variable or column names.

 

I appreciate if someone help with the code.

 

Thank you all.

 

 

Super User
Posts: 11,343

Re: How to replace empty labels to variable name

Any place SAS uses labels will default to using the variable name if a label is not defined. Are you running into an issue because of a missing label?

Super User
Super User
Posts: 7,997

Re: How to replace empty labels to variable name

data class;
  set sashelp.class;
run;

data _null_;
  set sashelp.vcolumn (where=(libname="WORK" and memname="CLASS" and label="")) end=last;
  if _n_=1 then call execute('proc datasets library=work nolist; modify class ;');
  call execute(cat('attrib ',strip(name),' label="',strip(name),'";'));
  if last then call execute(';quit;run;');
run;

Using sashelp.class for example.

Occasional Contributor
Posts: 7

Re: How to replace empty labels to variable name

Thank you Smiley Happy
Super User
Super User
Posts: 7,083

Re: How to replace empty labels to variable name

Why?

Occasional Contributor
Posts: 7

Re: How to replace empty labels to variable name

Need to call the label names with starting numeric values

Ask a Question
Discussion stats
  • 5 replies
  • 139 views
  • 0 likes
  • 4 in conversation