Which one of the following automatic SAS macro variables contains the return code from a previously executed step?
The SAS data set ONE has a variable X on which an index has been created. The data sets ONE and THREE are sorted by X.Which one of the following SAS programs uses the index to select observations from the data set ONE?
Given the following SAS data set ONE:ONE -REP AREA COST -SMITH NORTH 100 -SMITH SOUTH 200 -JONES EAST 100 -SMITH NORTH 300 -JONES WEST 100 -JONES NORTH 200 -JONES NORTH 400 -SMITH NORTH 400 -JONES WEST 100 -JONES WEST 300 -The following SAS program is submitted:proc sql;select rep, area, count(*) as TOTALfrom onegroup by rep, area;quit;Which one of the following reports is generated?
Which one of the following SAS procedures changes a permanent format of a variable stored in a SAS data set?
Given the following SAS data set SASUSER.HIGHWAY:SASUSER.HIGHWAY -STEERING SEATBELT SPEED STATUS COUNTabsent no 0-29 serious 31absent no 0-29 not 1419absent no 30-49 serious 191absent no 30-49 not 2004absent no 50+ serious 216The following SAS program is submitted:%macro highway;proc sql noprint;select count(distinct status)into :numgrpfrom sasuser.highway;%let numgrp = &numgrpselect distinct statusinto :group1-:group&numgrpfrom sasuser.highway;quit;%do i = 1 %to &numgrpproc print data = sasuser.highway;where status = "&&group&i" ;run;%end;%mend;%highwayHow many reports are produced by the above program?
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?
