Which one of the following should be avoided when creating and using an SQL procedure view?
The following SAS program is submitted.filename sales ('external-file1' 'external-file2');data new;infile sales;input date date9. company $ revenue;run;Which one of the following is the result of including the FILENAME statement in this program?
The SAS data set ONE contains the variables X, Y, Z, and W.The following SAS program is submitted:proc transpose data = oneout = transname = new;by x;var y;run;Which one of the following contains all the names of the columns created by theTRANSPOSE procedure?
Given the following SAS data set ONE:ONE -JOB LEVEL SALARY -ACC 2 300 -SEC 1 100 -SEC 2 200 -MGR 3 700 -ACC 1 .ACC 3 .MGR 2 400 -The following SAS data set TWO is created:TWO -JOB LEVEL BONUS -ACC 2 30 -MGR 3 70 -MGR 2 40 -Which one of the following SAS programs creates data set TWO?
The following are values of the variable STYLE from the SAS data setSASUSER.HOUSES:SASUSERS.HOUSES -OBS STYLE -1 RANCH2 SPLIT3 CONDO4 TWOSTORY5 RANCH6 SPLIT7 SPLITThe following SAS program is submitted:proc sql noprint;select distinct styleinto :styles separated by ' 'from sasuser.housesorder by style;quit;Which one of the following is the value of the resulting macro variable?
The following SAS program is submitted:%let value = .5;%let add = 5;%let newval = %eval(&value + &add);Which one of the following is the resulting value of the macro variable NEWVAL?
