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

Ensurepass 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 Read More …

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

Ensurepass 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?   Read More …

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

Ensurepass 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; Read More …

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

Ensurepass 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 Read More …

Get all latest (August) Cisco A00-211 Actual Test 91-100

Ensurepass 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;   Read More …

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

Ensurepass 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 Read More …

Get all latest (August) Cisco A00-211 Actual Test 81-90

Ensurepass 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 Read More …

Get all latest (August) Cisco A00-211 Actual Test 61-70

Ensurepass 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 Read More …

Get all latest (August) Cisco A00-211 Actual Test 71-80

Ensurepass 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. Read More …

Get all latest (August) Cisco A00-211 Actual Test 41-50

Ensurepass QUESTION 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;   Read More …

Get all latest (August) Cisco A00-211 Actual Test 51-60

Ensurepass QUESTION 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 Read More …

Get all latest (August) Cisco A00-211 Actual Test 21-30

Ensurepass QUESTION 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 Read More …

Get all latest (August) Cisco A00-211 Actual Test 31-40

Ensurepass QUESTION 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 Read More …

Get all latest (August) Cisco A00-211 Actual Test 11-20

Ensurepass QUESTION 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:   Read More …

Get all latest (August) Cisco A00-211 Actual Test 1-10

Ensurepass QUESTION 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 Read More …