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