SAS Institute A00-201 Online Practice Questions and Exam Preparation

SAS Institute A00-201 Online Questions & Answers

• Question 31:

  A raw data file is listed below:

  1901 2 1905 1 1910 6 1925 . 1941 1

  The following SAS program is submitted and references the raw data file above:

  data coins; infile `file-specification'; input year quantity; run;

  Which one of the following completes the program and produces a non-missing value for the variable TOTQUANTITY in the last observation of the output data set?

  A. totquantity + quantity;
  B. totquantity = sum(totquantity + quantity);
  C. totquantity 0; sum totquantity;
  D. retain totquantity 0; totquantity = totquantity + quantity;
  A. totquantity + quantity;

• Question 32:

  Which one of the following ODS statement options terminates output being written to an HTML file?

  A. END
  B. QUIT
  C. STOP
  D. CLOSE
  D. CLOSE

• Question 33:

  The contents of the raw data file EMPLOYEE are listed below:

  ----|----10----|----20----|----30

  Ruth 39 11

  Jose 32 22

  Sue 30 33

  John 4044

  The following SAS program is submitted:

  data test;

  infile `employee';

  input employee_name $ 1-4;

  if employee_name = `Sue' then input age 7-8;

  else input idnum 10-11;

  run;

  Which one of the following values does the variable AGE contain when the name of the employee is "Sue"?

  A. 30
  B. 33
  C. 40
  D. (missing numeric value)
  B. 33

• Question 34:

  A raw data record is listed below:

  ----I----10---I----20---I----30 s On, Travis,

  The following output is desired:

  relation fristname son Travis

  Which one of the following SAS programs reads the data correctly?

  A. data family/dIm = ` , `; infile `file-specification'; input relation $ firstname $; run;
  B. options dIm = ` , `; data family; infile `file-specification'; input relation $ firstname $; run;
  C. data family; infile `file-specification' dim = ` , `; input relation $ firstname $; run;
  D. data family, infile `file-specification'; input relation $ firstname $ / dIm = ` , `; run;
  C. data family; infile `file-specification' dim = ` , `; input relation $ firstname $; run;

• Question 35:

  The following SAS program is submitted:

  data numrecords;

  mule `file-specification';

  mnput@1 patient $15.

  relative$ 16-26@;

  if relative = `children' then

  input @54 diagnosis $15. @;

  else if relative = `parents' then

  input @28 doctor $15.

  clinic $ 44-53

  @54 diagnosis $15. @;

  input age;

  run;

  How many raw data records are read during each iteration of the DATA step during execution?

  A. 1
  B. 2
  C. 3
  D. 4
  A. 1

• Question 36:

  The contents of the SAS data set PERM.JAN_SALES are listed below:

  A comma delimited raw data tile needs to be created from the PERM.JAN_SALES data set.

  VARIABLE NAME TYPE idnum character variable sales_date numeric date value

  The SALES_DATE values need to be in a MMDDYY10 form.

  Which one of the following SAS DATA steps correctly creates this raw data file?

  A. libname perm `SAS-data-library'; data_null; set perm.jan_sales; file `file-specification' dsd = `,'; put idnum sales_date: mmddyy10.; run;
  B. libname perm `SAS-data-library'; data_null_; set perm.jan_sales; file `file-specification' dIm = `,'; put idnum sales_date : mmddyy10.; run;
  C. libname perm `SAS-data-library'; data_null_; set perm.jan_sales; file `file-specification'; put idnum sales_date : mmddyq10.dIm = `,'; run;
  D. libname perm `SAS-data-library"; data_null_; set perm jan_sales; file `file-specification'; put idnum sales_date: mmddyy10. dsd = `,'; put idnum sales_date: mmddw10. dsd = `,'; run;
  B. libname perm `SAS-data-library'; data_null_; set perm.jan_sales; file `file-specification' dIm = `,'; put idnum sales_date : mmddyy10.; run;

• Question 37:

  The following SAS program is submitted:

  data_null_;

  set old;

  put sales 1 sales2;

  run;

  Where is the output written?

  A. the SAS log
  B. the raw data file that was opened last
  C. the SAS output window or an output file
  D. the data set mentioned in the DATA statement
  A. the SAS log

• Question 38:

  The contents of the raw data file PRODUCT are listed below:

  ----I----10---I----20---I----30

  24613 $25.31

  The following SAS program is submitted:

  data inventory; infile `product'; input idnum 5. @10 price; run;

  Which one of the following is the value of the PRICE variable?

  A. 25.31
  B. $25.31
  C. . (missing numeric value)
  D. No value is stored as the program fails to execute due to errors.
  C. . (missing numeric value)

• Question 39:

  The following SAS program is submitted:

  options pageno = 1;

  proc print data = sasuser.houses;

  run;

  proc means data = sasuser.shoes;

  run;

  The report created by the PRINT procedure step generates 5 pages of output.

  What is the page number on the first page of the report generated by the MEANS procedure step?

  A. 1
  B. 2
  C. 5
  D. 6
  D. 6

• Question 40:

  The following SAS program is submitted:

  libname sasdata `SAS-data-library';

  data test;

  set sasdata.chemists;

  if jobcode = `chem3'

  then description = `Senior Chemist';

  else description = `Unknown';

  run;

  A value for the variable JOBCODE is listed below:

  JOBCODE

  CHEM3

  Which one of the following values does the variable DESCRIPTION contain?

  A. chem3
  B. Unknown
  C. Senior Chemist
  D. ` `(missing character value)
  B. Unknown