05-30-2017 10:40 AM
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.
05-30-2017 10:44 AM
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?
05-30-2017 10:48 AM
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.