Renaming Observations in a Data Set. Using PROC SQL?

[interlockjohn]

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 · Accepted solution]

A classic use of the Modify Statement.

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

[interlockjohn]

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

[Kurt_Bremser]

Just for completeness, the SQL code:

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