topic Re: how to proceed with Renaming the label as same as variable name? in SAS Programming

how to proceed with Renaming the label as same as variable name?

Prash — Wed, 15 Jul 2015 12:10:36 GMT

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

Re: how to proceed with Renaming the label as same as variable name?

Kurt_Bremser — Wed, 15 Jul 2015 12:28:54 GMT

Use PROC SQL with the ALTER TABLE and MODIFY statements: Base SAS(R) 9.2 Procedures Guide

Re: how to proceed with Renaming the label as same as variable name?

Ksharp — Wed, 15 Jul 2015 12:54:24 GMT

A good way is removing these LABELs.

Code: Program

data SS_2014_V4;

label SKL = 'SplKlLoun';
SKL = 1;
run;
proc datasets library=work nodetails nolist;
 modify SS_2014_V4;
  attrib _all_ label=" ";
quit;

Re: how to proceed with Renaming the label as same as variable name?

Tom — Wed, 15 Jul 2015 13:15:33 GMT

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.