SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 231:

  The following SAS program is submitted:

  

  Which statement is true about the output data set?

  A. The type of the variable CharEmpid is numeric.
  B. The type of the variable CharEmpid is unknown.
  C. The type of the variable CharEmpid is character.
  D. The program fails to execute due to errors.
  D. The program fails to execute due to errors.

• Question 232:

  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
  D. No output is generated.
  D. No output is generated.

• Question 233:

  The following SAS program is submitted:

  data WORK.AUTHORS;

  array Favorites{3} $ 8 ('Shakespeare','Hemingway','McCaffrey');

  run;

  What is the value of the second variable in the dataset WORK.AUTHORS?

  A. Hemingway
  B. Hemingwa
  C. ' ' (a missing value)
  D. The program contains errors. No variables are created.
  B. Hemingwa

• Question 234:

  The following SAS program is submitted:

  

  What is the value of the variable var1?

  A. `1/15/1960'
  B. 15
  C. 1151960
  D. 14
  D. 14

• Question 235:

  Given the raw data file AMOUNT:

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

  $1,234

  The following SAS program is submitted:

  data test;

  infile `amount';

  input@1 salary 6.;

  if_error_then description = `Problems';

  else description = `No Problems'; run;

  What is the result?

  A. The value of the DESCRIPTION variable is No Probl.
  B. The value of the DESCRIPTION variable is Problems.
  C. The value of the DESCRIPTION variable is No Problems.
  D. The value of the DESCRIPTION variable can not be determined.
  B. The value of the DESCRIPTION variable is Problems.

• Question 236:

  The following output is created by the FREQUENCY procedure:

  

  Which TABLES option(s) would be used to eliminate the row and column counts and just see the frequencies and percents?

  A. norowcount nocolcount
  B. freq percent
  C. norow nocol
  D. nocounts
  C. norow nocol

• Question 237:

  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 (only the first word).
  B. The label of the variable Jobcode is Job Desc (only the first 8 characters).
  C. The label of the variable Jobcode is Job Description.
  D. The program fails to execute due to errors. Labels must be defined in a PROC step.
  C. The label of the variable Jobcode is Job Description.

• Question 238:

  The following SAS SORT procedure step generates an output data set:

  proc sort data = sasuser.houses out = report;

  by style;

  run;

  In which library is the output data set stored?

  A. WORK
  B. REPORT.
  C. HOUSES
  D. SASUSER
  A. WORK

• Question 239:

  Which step sorts the observations of a permanent SAS data set by two variables and stores the sorted observations in a temporary SAS data set?

  A. proc sort out=EMPLOYEES data=EMPSORT; by Lname and Fname; run;
  B. proc sort data=SASUSER.EMPLOYEES out=EMPSORT; by Lname Fname; run;
  C. proc sort out=SASUSER.EMPLOYEES data=WORK.EMPSORT; by Lname Fname; run;
  D. proc sort data=SASUSER.EMPLOYEES out=SASUSER.EMPSORT; by Lname and Fname; run;
  B. proc sort data=SASUSER.EMPLOYEES out=EMPSORT; by Lname Fname; run;

• Question 240:

  Given the SAS data set WORK.ORDERS:

  

  Ship_date is a numeric variable containing a SAS data value. A programmer would like to create a new character variable Ship_date-char that represents the ship date as a character string, such as "February 2,2009' Which statement will create the new variable Ship_date_char as a character value with a format such as "February 2, 2009"?

  A. Ship_date_char = input(Ship_date, date9.,worddate20.);
  B. Ship_date_char = put(Ship_date, date9.,worddate20.);
  C. Ship_date_char = input(Ship_date,worddate20.);
  D. Ship_date_char = put(Ship_date,worddate20.);
  D. Ship_date_char = put(Ship_date,worddate20.);