Tag - A00-231 exam

Which program displays a listing of all data sets in the SASUSER library?A . proc contents lib = sasuser.all; run; B. proc contents data = sasuser.all; run; C. proc contents lib = sasuser._alI_; run; D. proc contents data = sasuser._all_; run;View AnswerAnswer: D

A user-defined format has been created using the FORMAT procedure. Where is it stored?A . in a SAS catalog B. in an external binary file C. in a SAS dataset in the WORK library D. in a SAS dataset in a permanent SAS data libraryView AnswerAnswer: A

The following SAS program is submitted: data one; date = ‘04juI2005’d; format date weekdate.; run; proc print data = one; run; What output is generated?A . Obs date 1 Monday, July 4, 2005 B. Obs date 1 July4, 2005 C. Obs date 1 04Jul2005 D. Obs date 1 Monday, 07/04/2005View...

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

The following SAS program is submittad: data work.sales; do year = 1 to 5; do month=1 to 12; x+1; output end; end; run; How many observations are written the WORK SALES data set?A . 0 B. 1 C. 5 D. 60View AnswerAnswer: D

1941 1 The following SAS program is submitted: data coins; infile ‘yearamt’; input year quantity; <insert statement(s) here> run; Which statement(s) completed the program and produced a non-missing value for the variable TOTQUANTITY in the final observation of the output data set?A . totquantity + quantity; B. totquantity = sum(totquantity...

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

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 named WORKSALARY contains 10 observations for each department, and is currently ordered by DEPARTMENT. Which statement is true?A ....

Given the SAS data set EMPLOYEES: EMPLOYEES NAME SALARY -------- ------------ Innis60000 Jolli50000 Ellis55000 Liu45000 The following SAS program is submitted: proc print data = employees; where name like ‘_i%’; run; What is contained in the output?A . Liu only B. Innis and Ellis only C. Innis, Ellis, and Liu...

The following code was modified to generate the results further below: proc format; value agegrp low-12 ='Pre-Teen' 13-high = 'Teen'; run; proc means data=SASHELP.CLASS; var Height; class Sex Age; format Age agegrp.; run; The following results were generated to display only specific statistics and limit the decimals with the modification:...