Which statement is true concerning the SAS automatic variable _ERROR_?

Which statement is true concerning the SAS automatic variable _ERROR_?A . It cannot be used in an if/then condition. B. It cannot be used in an assignment statement. C. It can be put into a keep statement or keep= option. D. It is automatically dropped.View AnswerAnswer: D

September 13, 2022 No Comments READ MORE +

Assuming that SASUSER.ONE exists, how many temporary and permanent SAS data sets are created?

The following SAS program is submitted: data ONE TWO SASUSER.TWO set SASUSER.ONE; run; Assuming that SASUSER.ONE exists, how many temporary and permanent SAS data sets are created?A . 2 temporary and 1 permanent SAS data sets are created B. 3 temporary and 2 permanent SAS data sets are created C....

September 13, 2022 No Comments READ MORE +

Which INFORMAT correctly completes the program?

Given the contents of the raw data file EMPLOYEE: ----|----10----|----20----|----30 Alan 19/2/2004 ACCT Rob 22/5/2004 MKTG MaryJane 14/3/2004 EDUC The following SAS program is submitted: data emps; infile ‘employee’; input@1 name$ @15 date <insert INFORMAT here> @25 department$; run; Which INFORMAT correctly completes the program?A . date9. B. ddmmyyyy9. C....

September 13, 2022 No Comments READ MORE +

Which SAS program temporarily replaces the label “Asking Price” with the label “Sale Price” in the output?

The SAS data set SASUSER.HOUSES contains a variable PRICE which has been assigned a permanent label of “Asking Price”. Which SAS program temporarily replaces the label “Asking Price” with the label “Sale Price” in the output?A . proc print data = sasuser.houses; label price = “Sale Price”; run; B. proc...

September 12, 2022 No Comments READ MORE +

Why does the program rail to execute?

The following SAS program is submitted: proc sort data = work.employee; by descending fname; proc sort data = work.salary; by descending fname; data work.empdata; merge work.employee work.salary; by fname; run; Why does the program rail to execute?A . The SORT procedures contain invalid syntax. B. The merged data sets are...

September 12, 2022 No Comments READ MORE +

Which statement best describes the output from the submitted program?

The following program is submitted: proc contents data=_all_; run; Which statement best describes the output from the submitted program?A . The output contains only a list of the SAS data sets that are contained in the WORK library. B. The output displays only the contents of the SAS data sets...

September 12, 2022 No Comments READ MORE +

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,...

September 12, 2022 No Comments READ MORE +

How will the Exam variable value be displayed in the FREQ procedure output?

The following SAS program is submitted: How will the Exam variable value be displayed in the FREQ procedure output?A . Fail B. Pass C. 50.5 D. .(missing numeric value)View AnswerAnswer: C

September 12, 2022 No Comments READ MORE +

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...

September 11, 2022 No Comments READ MORE +

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

September 11, 2022 No Comments READ MORE +