- All Exams Instant Download
What describes the SAS automatic _ERROR_ variable?
What describes the SAS automatic _ERROR_ variable?A . The _ERROR_ variable contains the values ‘TRUE’ or ‘FALSE.’ B. The _ERROR variable maintains a count of the number of data errors. C. The _ERROR_ variable can be used in expressions or calculations in the DATA step. D. The ERROR_variable contains the...
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 ....
What changes should be made to the KEEP statement to correct the errors in the LOG?
After a SAS program is submitted, the following is written to the SAS log: 105 data january; 106 set allmonths(keep = product month num_sold cost); 107 if month = ‘Jan’ then output january; 108 sales = cost * num_sold; 109 keep = product sales; ------ 22 ERROR 22-322: Syntax error,...
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...
Which of the following is true concerning the submitted program?
The following program is submitted: proc sort data=SASUSER.PROJECTS out=PSORT; by Code descending Date Cost; run; Which of the following is true concerning the submitted program?A . The descending option applies to the variable Code. B. The variable Code is sorted by ascending order. C. The PSORT data set is stored...
Which TABLES statement was used to completed the following program that produced the output?
The following output is created by the FREQUENCY procedure: Which TABLES statement was used to completed the following program that produced the output? proc freq data=sales; <_insert_code_> run;A . tables region product; B. tables region,product C. tables region/product; D. tables region*product;View AnswerAnswer: D
What is the value of the TOTALPASSENGERS variable in the output data set?
The following SAS program is submitted: data work.passengers; if OrigPassengers = . then' OrigPassengers = 100; TransPassengers = 100; OrigPassengers = .; TotalPassengers = sum (OrigPassengers, TransPassengers) +0; run; What is the value of the TOTALPASSENGERS variable in the output data set?A . 0 B. 100 C. 200 D. (missing...
How many observations are written to the WORK.SALES data set?
The following SAS program is submitted: How many observations are written to the WORK.SALES data set?A . 0 B. 1 C. 5 D. 60View AnswerAnswer: B
How many observations are in data set WORK.ALL after submitting the program?
Given the SAS data set WORK.EMP_NAME: Given the SAS data set WORK.EMP_DEPT: The following program is submitted: How many observations are in data set WORK.ALL after submitting the program?A . 1 B. 2 C. 3 D. 5View AnswerAnswer: B
Which ODS statements inserted, respectively, in the two location above creates a report stored in an html file?
The following SAS program is submitted: <_insert_ods_code_> proc means data=SASUSER.SHOES; where Product in ('Sandal' , 'Slipper' , 'Boot'); run; <_insert_ods_code_> Which ODS statements inserted, respectively, in the two location above creates a report stored in an html file?A . ods html open='sales.html';ods html close; B. ods file='sales.html' / html;ods file...
