84 data work.empsalary;
85 set work.people (in = inemp) work.money (in = insal);
86 if insal and inemp;
NOTE: There were 5 observations read from the data set WORK.PEOPLE.
NOTE: There were 7 observations read from the data set WORK.MONEY.
NOTE: The data set WORK.EMPSALARY has 0 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.03 seconds
Option A is correct here because the IF condition includes an AND clause, which means only those observations for which both datasets contributed will be written. And here one dataset contains 5 observations and the other contains 7 observations.
If the OR comparison operator were used in the IF condition then the dataset empsalary would append as usual .
Ankan Jun 03, 2015hydroweaver Jun 10, 2015rclay Aug 05, 2016
NYCRaven Oct 06, 2017
Rockeps Oct 10, 2016shovland Jan 02, 2017NYCRaven Oct 06, 2017
Bi Exam Academy
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.