What is the purpose of the SASFILE statement?
Given the SAS date sets CLASS1 and CLASS2CLASS1 CLASS2 -NAME COURSE NAME COURSE -Lauren MATH1 Smith MATH2 -Patel MATH1 Farmer MATH2 -Chang MATH1 Patel MATH2 -Chang MATH3 Hiller MATH2 -The following SAS program is submitted:Proc sql;Select name from CLASS1 -<insert SQL set operator here>select name from CLASS;quit;The following output is desired -NAME -Chang -Chang -Lauren -Which SQL set operator completes the program and generates the desired output?
The following SAS program is submitted:data new (bufnp=4);set old(bufno=4);run;Why are the BUFNO options used?
The following SAS program is submitted:options reuse=YES;data sasuser RealEstate(compress=CHAR);set sasuser houses;run;What is the effect of the REUSE=YES SAS system option?
The SAS data set ONE contains fifty million observations and contains the variablePRICE, QUANTITY, FIXED and VARIABLE. Which SAS program successfully creates three new variables TOTREV, TOTCOST and PROFIT and requires the least amount of CPU resources to be processed?
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?
