SAS Certification Prep Guide, 4th Edition

Renaming Variables

The Basics of Renaming Variables

DATA step match-merging overwrites values of the like-named variable in the first data set in which it appears with values of the like-named variable in subsequent data sets.

Consider Clinic.Demog, which contains the variable Date (date of birth), and Clinic.Visit, which also contains Date (date of the clinic visit in 1998). The DATA step below overwrites the date of birth with the date of the clinic visit.

data clinic.merged; 
   merge clinic.demog clinic.visit; 
   by id; 
run; 
proc print data=clinic.merged; 
run;

The following output shows the effects of overwriting the values of a variable in the Clinic.Merged data set. In most observations, the date is now the date of the clinic visit. In observation ...