I have this case where I want to rename the label as same as variable name, for example
I have the variable name 'Fundplatinum' however label shows as 'fnd pltnm' ( Previously from the raw file after importing I had renamed only the variable and not the label )
How to go ahead about renaming the label now?
I am aware of renaming the label and variable at the same time, like this
data SS_2014_V4;
set SS_2014_V3;
label SKL = 'SplKlLoun';
rename SKL = SplKLoun;
run;
But not aware of renaming label only, can we use proc dataset?
I understand that label names doesn't make any difference but want to know how to rename label only ?
Thanks
Prash
Use PROC SQL with the ALTER TABLE and MODIFY statements: Base SAS(R) 9.2 Procedures Guide
Use PROC SQL with the ALTER TABLE and MODIFY statements: Base SAS(R) 9.2 Procedures Guide
A good way is removing these LABELs.
data SS_2014_V4;
label SKL = 'SplKlLoun';
SKL = 1;
run;
proc datasets library=work nodetails nolist;
modify SS_2014_V4;
attrib _all_ label=" ";
quit;
The LABEL statement attaches the label to the variable. It is not really the same thing as renaming a variable.
If you set the label to blank then in most places SAS will just use the variable name.
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 16. 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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: