Category: A00-211 Real Exam (August)

EnsurepassQUESTION 131 The following SAS program is submitted and reads 100 records from a raw data file:   data work.total;   infile 'file-specification' end = eof;   input name $ salary;   totsal + salary;   run;   Which one of the following IF statements writes the last observation to the output data set?   A. if end = 0; B. if eof = 0; C. if end = 1; D. if eof = 1;   Correct Answer: D     QUESTION 132 The following SAS program is Read more [...]

EnsurepassQUESTION 141 The following SAS program is submitted:   data WORK.OUTDS;   do until(Prod GT 6);   Prod + 1;   end;   run;   What is the value of the variable Prod in the output data set?   A. . (missing) B. 6 C. 7 D. Undetermined, infinite loop.   Correct Answer: C     QUESTION 142 The following SAS program is submitted:   libname sasdata 'SAS-data-library';   data test;   set sasdata.chemists;   if jobcode Read more [...]

EnsurepassQUESTION 111 The following SAS program is submitted:   data work.totalsales (keep = monthsales{12} );   set work.monthlysales (keep = year product sales);   array monthsales {12} ;   do i=1 to 12;   monthsales{i} = sales;   end;   run;   The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.   Which one of the following is the result of the above program?   A. The program Read more [...]

EnsurepassQUESTION 121 The following SAS program is submitted:   proc sort data = sasuser.houses out = houses;   by style;   run;   proc print data = houses;   run;   Click on the Exhibit button to view the report produced.   style bedrooms baths price CONDO 2 1.5 80050   3 2.5 79350   4 2.5 127150   2 2.0 110700   RANCH 2 1.0 64000   3 3.0 86650   3 1.0 89100   1 1.0 34550   SPLIT 1 1.0 65850   4 3.0 94450   3 1.5 Read more [...]

EnsurepassQUESTION 91 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 Month All Products C. All Products All Regions All Figures Read more [...]

EnsurepassQUESTION 101 The following SAS program is submitted:   data _null_;   set old (keep = prod sales1 sales2);   file 'file-specification';   put sales1 sales2;   run;   Which one of the following default delimiters separates the fields in the raw data file created?   A. : (colon) B. (space) C. , (comma) D. ; (semicolon)   Correct Answer: B             QUESTION 102 The following SAS DATA step is submitted:   Read more [...]

EnsurepassQUESTION 81 Given the raw data file EMPLOYEE:   ---I----1 0---I----20---I----30   Ruth 39 11   Jose 32 22   Sue 30 33   John 40 44   The following SAS program is submitted:   data test;   infile `employee';   input employee_name $ 1-4;   if employee_name = `Ruth' then input idnum 10-11;   else input age 7-8;   run;   What value does the variable IDNUM contain when the name of the employee is "Ruth"?   A. 11 B. Read more [...]

EnsurepassQUESTION 61 The SAS data set WORK.ONE contains a numeric variable named Num ana character variable named Char:   WORK.ONE   Num Char   ----- ------   1 23   3 23   1 77   The following SAS program is submitted:   proc print data=WORK.ONE;   where Num='1';   run;   What is output?   A. Num Char -- ---- 1 23 B. Num Char -- ---- 1 23 1 77 C. Num Char -- ---- 1 23 3 23 1 77 D. No output is generated.   Correct Answer: Read more [...]

EnsurepassQUESTION 71 Given the contents of the raw data file TYPECOLOR.DAT:     The following SAS program is submitted:     What are the values of the variables Type and Color?   A. Type=daisy, Color=yellow B. Type=daisy, Color=w C. Type=daisy, Color=daisyyellow D. Type=daisy, Color=   Correct Answer: D     QUESTION 72 The following SAS program is submitted:     How many observations are written to the WORK.SALES data set?   Read more [...]

EnsurepassQUESTION 41 Given the SAS data set SASDATA TWO:   SASDATA TWO   XY   ---   52   31   56   The following SAS program is submitted:   data sasuser.one two sasdata.three;   set sasdata two;   if x = 5 then output sasuser.one;   else output sasdata two;   run;   What is the result?   A. data set SASUSER.ONE has 5 observations data set SASUSER.TWO has 5 observations data set WORK.OTHER has 3 observations B. data set Read more [...]

EnsurepassQUESTION 51 The following SAS program is submitted:   data WORK.ACCOUNTING;   set WORK.DEPARTMENT;   label Jobcode='Job Description';   run;   Which statement is true about the output dataset?   A. The label of the variable Jobcode is Job (only the first word). B. The label of the variable Jobcode is Job Desc (only the first 8 characters). C. The label of the variable Jobcode is Job Description. D. The program fails to execute due to errors. Labels Read more [...]

EnsurepassQUESTION 21 The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below:   WORK.EMPLOYEE WORK.SALARY   fname age name salary   Bruce 30 Bruce 25000   Dan 40 Bruce 35000   Dan 25000   The following SAS program is submitted:   data work.empdata;   by fname;   totsal + salary; run;   Which one of the following statements completes the merge of the two data sets by the FNAME variable?   A. merge work.employee work.salary (fname Read more [...]

EnsurepassQUESTION 31 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)   Correct Answer: C QUESTION 32 The following SAS program is submitted:   data work.sets;   do until (prod gt 6);   prod + 1;   end;   run;   What is the value of the variable PROD in the output data set?   A. 6 B. 7 C. 8 Read more [...]

EnsurepassQUESTION 11 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. Read more [...]

EnsurepassQUESTION 1 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 that are contained in the WORK library. C. The output displays only the variables in the SAS data sets that are contained in the WORK library. D. Read more [...]