Given the following SAS data set ONE:ONE -CATEGORY AGE SALARY BONUS -----M 28 200 .M 25 100 10 -F 18 100 50 -F 25 200 10 -The following SAS program is submitted:proc sql;create table two asselect category, salary + bonus as EARNINGSfrom one; quit;Which one of the following represents the data values stored in the data set TWO?
Which one of the following SAS SORT procedure options eliminates identical consecutive observations?
The following SAS program is submitted:data temp;array points{3,2}_temporary_ (10,20,30,40,50,60);score = points{2,1}run;Which one of the following is the value of the variable SCORE in the data set TEMP?
The following SAS FORMAT procedure is submitted:proc format lib = sasuser;value tempc low < 0 = 'BELOW FREEZING'0 < 5 = 'COLD'5 < 10 = 'MILD'10 < 15 = 'WARM'15 high = 'HOT';run;How is the value 10 displayed when the format TEMPC is applied?
Which one of the following SAS programs uses the most amount of memory resources for output buffers?
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?
