Which one of the following programs contains a syntax error?
The following SAS code is submitted:%macro houses(dsn = houses,sub = RANCH);data &dsnset sasuser.houses;if style = "";run;%mend;%houses(sub = SPLIT)%houses(dsn = ranch)%houses(sub = TWOSTORY)Which one of the following is the value of the automatic macro variable SYSLAST?
Given the following SAS data sets ONE and TWO:ONE TWO -NUM COUNTRY NUM CITY -1 CANADA 3 BERLIN2 FRANCE 5 TOKYO3 GERMANY 4 BELGIUM5 JAPANThe following SAS program is submitted:proc sql;select countryfrom onewhere not exists(select *from twowhere one.num = two.num);quit;Which one of the following reports is generated?
Which one of the following statements is true?
The variable attributes of SAS data sets ONE and TWO are shown below:ONE TWO -# Variable Type Len Pos # Variable Type Len Pos2 sales Num 8 8 2 budget Num 8 81 year Num 8 0 3 sales Char 8 161 year Num 8 0Data set ONE contains 100 observations. Data set TWO contains 50 observations. Both data sets are sorted by the variable YEAR.The following SAS program is submitted:data three;merge one two;by year;run;Which one of the following is the result of the program execution?
The following SAS program is submitted:Data sasuser.history;Set sasuser.history(keep=state x yRename = (state=ST));Total=sum(x, y);Run;The SAS data set SASUSER.HISTORY has an index on the variable STATE.Which describes the result of submitting the SAS program?
