How to replace empty labels to variable name

[SanthSG]

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.

[ballardw]

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?

[RW9]

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.

[SanthSG]

Thank you 🙂

[Tom]

Why?

[SanthSG]

Need to call the label names with starting numeric values