topic Re: Renaming Observations in a Data Set. Using PROC SQL? in SAS Programming

Renaming Observations in a Data Set. Using PROC SQL?

interlockjohn — Tue, 10 Dec 2019 10:32:09 GMT

Hi all,

I have a data set attached with observations that are "ADIN MOUTAIN’" and I would like to change them to "ADIN MOUNTAIN."

Can I use PROC SQL to do this? How do change the observations names without creating a new data set?

PeterClemmensen — Tue, 10 Dec 2019 10:37:09 GMT

A classic use of the Modify Statement.

data SNOWSTATIONSDATA8711;
   modify SNOWSTATIONSDATA8711;
   if STATIONNAME = "ADIN MOUTAIN" then STATIONNAME="ADIN MOUNTAIN";
run;

interlockjohn — Tue, 10 Dec 2019 10:52:01 GMT

Ah, I kept trying to look up SAS documentation using rename, and only got results for renaming variables. Thank you very much.

Kurt_Bremser — Tue, 10 Dec 2019 11:45:26 GMT

Just for completeness, the SQL code:

proc sql;
update snowstationsdata
set stationname = 'ADIN MOUNTAIN'
where stationname = 'ADIN MOUTAIN';
quit;