QUESTION 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 = 'chem3' Read more [...]
QUESTION 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 submitted: Read more [...]
QUESTION 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 73650   Read more [...]
QUESTION 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 fails Read more [...]
QUESTION 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:   libname Read more [...]
QUESTION 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 in Thousands Read more [...]
QUESTION 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. 22 C. Read more [...]
QUESTION 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?   A. 0 Read more [...]
QUESTION 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: D   Read more [...]