Get all latest (August) Cisco A00-211 Actual Test 141-150

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

Get all latest (August) Cisco A00-211 Actual Test 131-140

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

Get all latest (August) Cisco A00-211 Actual Test 121-130

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

Get all latest (August) Cisco A00-211 Actual Test 111-120

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

Get all latest (August) Cisco A00-211 Actual Test 101-110

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