Given the following SAS program:proc sql;select product, type, sum(sales) as revenuefrom onegroup by product, type;quit;Which one of the following clauses should be added to the program to sort the output by PRODUCT and decreasing REVENUE?
The following SAS program is submitted:%macro test(var);proc print data = sasuser.class;where age > &varrun;%mend;Which type of parameter is the macro variable VAR?
The following SAS program is submitted:proc datasets lib = testdata;modify one;label num = 'Number';format num 4.;quit;Which one of the following SQL programs produces the same results as the above DATASETS procedure?
Which one of the following techniques concatenates data in SAS?
In which one of the following SAS programs is the SAS data set index named CHAR1 always used?
Given the following SAS data set ONE:ONE -CATEGORY AGE SALARY BONUS -M 28 200 20 -M 25 100 10 -M 28 300 10 -M 33 300 30 -F 18 100 50 -F 25 200 10 -F 35 400 50 -The following SQL program is submitted:proc sql;create table two asselect distinct agefrom onewhere age < 33;quit;How many rows are written to the SAS data set TWO?
