- All Exams Instant Download
What is the cause of the syntax error?
The following SAS program is submitted: The program fails execution due to syntax errors. What is the cause of the syntax error?A . The variable MONTHSALES does not exist. B. An array cannot be referenced on a KEEP data set option. C. The KEEP= data set option should be (KEEP...
What is the cause of the syntax error?
Given the AIRPLANES data set AlRPLANES TYPE MPG -------- ------ F-18 105 C-130 25 Harrier 75 A-6 110 The following SAS program is submitted: data gt100; set airplanes(keep = type mpg load); load = mpg * 150; run; The program fails to execute due to syntax errors. What is the...
Which of the following is true?
The following SAS program is submitted: data test; infile ‘file specification’; input name $ amount@@; run; Which of the following is true?A . Two @@ together are the same as one c. B. Two @@ hold the data records until the bottom of the DATA step. C. Two @@ hold...
Which FORMAT statement displays the value as $110,700.00 in a report?
The value 110700 is stored in a numeric variable named SALARY. Which FORMAT statement displays the value as $110,700.00 in a report?A . format salary comma11.2; B. format salary dollar8.2; C. format salary dollar11.2; D. format salary comma8.2 dollar8.2;View AnswerAnswer: C
What is the result?
The following SAS program is submitted: data work.retail; cost = ‘20000’; total= .10* cost run; What is the result?A . The value of the variable TOTAL in the output data set is 2000. No messages are written to the SAS log. B. The value of the variable TOTAL in the...
Which PROC PRINT step correctly displays the NORTH worksheet?
The Excel workbook REGIONS.XLS contains the following four worksheets: EAST WEST NORTH SOUTH The following program is submitted: libname MYXLS 'regions.xls'; Which PROC PRINT step correctly displays the NORTH worksheet?A . proc print data=MYXLS.NORTH;run; B. proc print data=MYXLS.NORTH$;run; C. proc print data=MYXLS.'NORTH'e;run; D. proc print data=MYXLS.'NORTH$'n;run;View AnswerAnswer: D
What is the result?
The SAS data set PETS is sorted by the variables TYPE and BREED. The following SAS program is submitted: proc print data = pets; var type breed; sum number; run; What is the result?A . The SUM statement produces only a grand total of NUMBER. B. The SUM statement produces...
What is the result?
The following SAS program is submitted: data work.total; set work.salary(keep = department wagerate); by department; if first.department then payroll = 0; payroll + wagerate; if last.department run; The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments. What is the result?A . The...
Where is the output written?
The following SAS program is submitted: Data_null_; set old; put sales 1 sales2; run; Where is the output written?A . to the SAS log B. to the SAS data set _NULL_ C. to the SAS output window or to an output file D. to the raw data file that was...
What is written to the output raw data file?
Given the SAS data set PEPM.STUDENTS: PERM.STUDENTS NAME AGE Alfred 14 Alice13 Barbara13 Carol14 The following SAS program is submitted: libname perm ‘SAS data library’; data students; set perm. Students; file ‘file specification’; put name $15. @5 age 2.; run; What is written to the output raw data file?A ....
