Question3:ThefollowingSASprogramissubmitted:
datawork.january;
setwork.allmonths(keep=productmonthnum_soldcost);
ifmonth='Jan'thenoutputwork.january;
sales=cost*num_sold;
keep=productsales;
run;
WhichvariablesdoestheWORK.JANUARYdatasetcontain?
1.PRODUCTandSALESonly
2.PRODUCT,MONTH,NUM_SOLDandCOSTonly
3.PRODUCT,SALES,MONTH,NUM_SOLDandCOSTonly
4.Anincompleteoutputdatasetiscreatedduetosyntaxerrors
CorrectAnswer:4
Exp:Asthereissyntaxerror.
"keep=productsales"whichistheincorrectwaytouseKEEPoption
Ithassyntaxerrorisitdueto
1)ifmonth='Jan'thenoutputwork.january;or
2)keep=productsales;
Forsureifitiswithdataline(drop=variables)andnoneed=inthebodyseparately.