The following SAS program is submitted:options mprint;%macro test(parm);proc &parm data = sashelp.prdsale;run;%mend;%test(print)What is the result of the MPRINT options?
Given the SAS data set ONE:ONE -REP COST -SMITH 200 -SMITH 400 -JONES 100 -SMITH 600 -JONES 100 -The following SAS program is submitted:Proc sql;Select rep, avg(cost) as AVERAGEFrom one -Group by rep -<insert SQL procedure clause here>quit;The following output is desired:Which SQL procedure clause completes the program and generates the desired output?
Given the data set SASHELP.CLASS:SASHELP.CLASS -NAME AGE -Mary 15 -Philip 16 -Robert 12 -Ronald 15 -The following SAS program is submitted:%let value = Philip;proc print data = sashelp.class;<insert WHERE statement here>run;Which WHERE statement successfully completes the program and procedures a report?
Given the SAS dataset ONE -ONE -SALARY -200205523The following SAS program is submittedProc sql;Select * from one -<Insert Where expression here>;quit;The following output is desired:SALARY -200205523Which WHERE expression completes the program and generates the desired output?
At the start of a new SAS session; the following program is submitted:%macro one;data _null_;call symput('proc','measn);run;proc &proc data=sashelp.class;run;%mend;%one()What is the result?
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?
