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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.