Below are my answers, please correct me if I'm wrong. Thank you!
*4a Answer: using the datasets I made up, the log window shows ERROR 411-185: The UPDATE statement requires two data sets, too many data sets have been specified.;
data one;
input ID SALARY;
datalines;
011 376
026 .
028 374
;
proc print;
title 'one';
run;
data two;
input ID SALARY;
datalines;
011 322
026 123
028 374
;
proc print;
title 'two';
run;
data three;
input ID SALARY;
datalines;
011 302
026 234
028 311
;
proc print;
title 'three';
run;
data new;
update one two three;
by id;
proc print;
title 'update one two three';
run;
*4b Answer: using the dataset I created, the log window shows no errors. Therefore, there is nothing wrong;
data transact;
input ID SALARY;
datalines;
011 376
026 .
028 374
;
proc print;
title 'Transact';
run;
data master;
input ID SALARY;
datalines;
011 245
026 269
028 374
;
proc print;
title 'Master';
run;
data new;
update transact master;
by id;
proc print;
title 'Update Transact with Master';
run;
... View more