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.
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?
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.
Why?
Need to call the label names with starting numeric values
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.