- All Exams Instant Download
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...
What is the purpose or the MISSOVER option on the INFILE statement?
What is the purpose or the MISSOVER option on the INFILE statement?A . It prevents SAS from loading a new record when the end of the current record is reached. B. It enables SAS to scan the input data records until the character string that is specified in the @‘character-string’...
Which footnote(s) is/are displayed in the report?
The following SAS program is submitted: footnote1 ‘Sales Report for Last Month’; footnote2 ‘Selected Products Only’; footnote3 ‘All Regions’; footnote4 ‘All Figures in Thousands of Dollars’; proc print data = sasuser.shoes; footnote2 ‘All Products’; run; Which footnote(s) is/are displayed in the report?A . All Products B. Sales Report for Last...
Which statement successfully completes the program so that TOTAL has a value of 505-6465-09090?
The following SAS program is submitted: data combine; prefix=’505’; middle=’6465 ‘; end=’09090’; <insert statement here>; run; Which statement successfully completes the program so that TOTAL has a value of 505-6465-09090?A . total = cat(’-’, prefix, middle, end); B. total = catx(’-’, prefix, middle, end); C. total = prefix !!’-’!! middle...
