topic Re: rename colum in SAS Procedures

rename colum

tjonas — Fri, 27 May 2011 14:58:02 GMT

Trying to rename a column titled country, I tried the code below but when it runs the column name is changed but the data is gone.

data births.father (drop=country);
set births.father;
country=dadbirthplacecountry;
run;

Re: rename colum

RickM — Fri, 27 May 2011 15:13:08 GMT

Do you have country and dadbirthplacecountry in the wrong sides of the equals sign? If all you are doing is renaming then proc datasets might be a better choice.

Re: rename colum

tjonas — Fri, 27 May 2011 15:16:36 GMT

thanks, that was it. I'm just learning sas.

Re: rename colum

SPR — Fri, 27 May 2011 15:21:23 GMT

Hello Tjonas,

Look at your code:

country=dadbirthplacecountry;

copies from dadbirthplacecountry to country. Then

data births.father (drop=country);

deletes country from output dataset. It means that if the input dataset birth.father does not contain dadbirthplacecountry then this column will be empty in the output dataset births.father. It looks like you neet the following:
[pre]
data births.father;
set births.father;
rename country=dadbirthplacecountry;
run;
[/pre]
Sincerely,
SPR