topic Re: Renaming variables mysterie in SAS Procedures

Renaming variables mysterie

Biniie — Sun, 05 Jan 2020 14:25:29 GMT

I have a simple dataset with two variable called "cc" and "ss", and I want to rename them using a datastep like the following:

data new_data;

set old_data;

rename cc=vcc ss=vss;

run;

After the datastep, I run a proc contents to see that the variable names are change correctly - which they are. But if I then afterwards opens the actual new dataset, where the new variable name should be assigned, then I can't see the newly assigned names - like nothing have happend at all.

Does anyone know, why this happens and how I can fix it?

Re: Renaming variables mysterie

novinosrin — Sun, 05 Jan 2020 14:45:38 GMT

HI @Biniie One possibility is that it may display labels if permanent labels are associated with variable names. Did you check that in proc contents by any chance as well?

Please post the proc contents output if you can. Thank you!

Other possibility though may sound silly, you might be opening the old_data

Re: Renaming variables mysterie

Biniie — Sun, 05 Jan 2020 14:47:35 GMT

Hi @novinosrin.

Of course!! It did show the variabels labels (which was identical with the old-names") instead of the variables names.

Thanks for solving my mysterie 🙂

Re: Renaming variables mysterie

novinosrin — Sun, 05 Jan 2020 14:52:04 GMT

Glad, that was the problem. Have fun! 🙂