Exam A00-211 topic 1 question 2 discussion

The crucial part of the program is the IF statement: if insal and inemp;. This line means that an observation will be included in the WORK.EMPSALARY data set only if it is present in both work.people (indicated by inemp) and work.money (indicated by insal). Therefore, no observations will meet the if insal and inemp; condition.

I think D is correct

Answer A is right. I think, IN option is mostly used when we are merging datasets. Also, it need by statement and both datasets must be sorted. I never seen example while learning where you are concatenating the datasets.

Sorry about the wrong code below please ignore it.

A is the correct answer. 0 obs. Run the following code and try to understand what is going on in the in= option. Uncomment the if statement and run it aging. You will get 0 obs. DATA CAFE(KEEP=NAME PLACE CNUM); INPUT NAME $ ; PLACE = 'CAFE '; CNUM = 'C' || LEFT(PUT(_N_,2.)); DATALINES; ANDERSON COOPER DIXON FREDERIC FREDERIC PALMER RANDALL RANDALL SMITH SMITH SMITH ; RUN; DATA VENDING (KEEP=NAME PLACE VNUM); INPUT NAME $ ; PLACE = 'VENDING '; VNUM = 'V' || LEFT(PUT(_N_,2.)); DATALINES; CARTER DANIELS GARY GARY HODGE PALMER RANDALL RANDALL SMITH SMITH SPENCER SPENCER SPENCER SPENCER ; RUN; DATA ALL; set CAFE(IN=CAFEIN) SNACK(IN=SNACKIN); CIN=CAFEIN; SIN=SNACKIN; *if CIN and SIN; RUN;

should be D.12?

reason why 0?