SAS OnlineTutor HomeFAQ PageSuggested Learning PathsContents+Searchback||next

Merging SAS Data Sets
Selecting Variables


Question:

Suppose you want to drop the variables Manager and EmpID from the Payroll.Allyears data set. In the following program, where should you specify the DROP= option?
data payroll.allyears;
   merge payroll.employee(in=inemp) payroll.accounts
(in=inacc rename=(date=PayDate)); by empid; if emptype='EXEMPT' and inemp and inacc; run;
You can drop both variables in the MERGE statement.
You must drop both variables in the DATA statement.
You can drop one variable in the MERGE statement, but you must drop the other variable in the DATA statement.


  back||next

 

Copyright © 2002 SAS Institute Inc., Cary, NC, USA. All rights reserved.

Terms of Use & Legal Information | Privacy Statement