topic How to replace empty labels to variable name in SAS Programming

How to replace empty labels to variable name

SanthSG — Tue, 30 May 2017 14:40:29 GMT

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.

Re: How to replace empty labels to variable name

ballardw — Tue, 30 May 2017 14:44:36 GMT

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?

Re: How to replace empty labels to variable name

RW9 — Tue, 30 May 2017 14:48:37 GMT

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.

Re: How to replace empty labels to variable name

Tom — Tue, 30 May 2017 15:35:31 GMT

Why?

Re: How to replace empty labels to variable name

SanthSG — Wed, 31 May 2017 10:42:52 GMT

Need to call the label names with starting numeric values

Re: How to replace empty labels to variable name

SanthSG — Wed, 31 May 2017 12:48:43 GMT

Thank you 🙂