235 data work.company;
236 set work.dept1(keep = jobcode)
237 work.dept2(rename = (jcode = jobcode));
NOTE: There were 3 observations read from the data set WORK.DEPT1.
NOTE: There were 3 observations read from the data set WORK.DEPT2.
NOTE: The data set WORK.COMPANY has 6 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.00 seconds
The RENAME dataset option is used in the statement work.dept2(rename = (jcode = jobcode)). This RENAME option changes the name of variable - in this case, the variable jcode is changed to jobcode.
Both data sets have the variable jobcode. SAS appends the DEPT1 and DEPT2 datasets and outputs the new dataset COMPANY.
The one and only FREE resource for general SAS online training as well as study guides for the SAS Base Certification. My goal is to create the SAS Certification prep guide that I never found but always wanted. This should also be a place to come if you are new to the language but are simply looking for online SAS training.