SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 161:

  Given the SAS data set WORK.PRODUCTS:

  

  How many observations does the WORK.OUTDOOR data set contain?

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

• Question 162:

  The following SAS program is submitted:

  libname sasdata 'SAS-data-library';

  data test;

  set sasdata.chemists (keep = job_code);

  if job_code = 'chem3'

  then description = 'Senior Chemist';

  run;

  The variable JOB_CODE is a character variable with a length of 6 bytes.

  Which one of the following is the length of the variable DESCRIPTION in the output data set?

  A. 6 bytes
  B. 8 bytes
  C. 14 bytes
  D. 200 bytes
  C. 14 bytes

• Question 163:

  The following SAS program is submittad:

  data work.sales;

  do year = 1 to 5;

  do month=1 to 12;

  x+1;

  output

  end;

  end;

  run;

  How many observations are written the WORK SALES data set?

  B. 1
  C. 5
  D. 60
  D. 60

• Question 164:

  After a SAS program is submitted, the following is written to the SAS log:

  105 data january;

  106 set allmonths(keep = product month num_sold cost);

  107 if month = `Jan' then output january;

  108 sales = cost * num_sold;

  109 keep = product sales;

  ERROR 22-322: Syntax error, expecting one of the following:!,

  !!, and, *,**, +, -,/, <,< =, <>, =, >, ><, >=,

  AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL,

  NOTIN, OR,^=,|,II,

  110 run;

  What changes should be made to the KEEP statement to correct the errors in the LOG?

  A. keep product sales;
  B. keep product, sales;
  C. keep = product, sales;
  D. keep = (product sales);
  A. keep product sales;

• Question 165:

  The following SAS program is submitted:

  libname temp `SAS data library';

  data temp.sales;

  merge temp.sales

  work.receipt;

  by names;

  run;

  The input data files are sorted by the NAMES variable:

  What is the result?

  A. The program executes successfully and a temporary SAS data set is created.
  B. The program executes successfully and a permanent SAS data set is created.
  C. The program fails execution because the same SAS data set is referenced for both read and write operations.
  D. The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.
  B. The program executes successfully and a permanent SAS data set is created.

• Question 166:

  The following SAS program is submitted:

  data WORK.DATE_INFO;

  X="01Jan1960" D;

  run;

  What variable X contains what value?

  A. the numeric value 0
  B. the character value "01Jan1960"
  C. the date value 01011960
  D. the code contains a syntax error and does not execute.
  A. the numeric value 0

• Question 167:

  The following SAS program is submitted:

  data work.pieces;

  do while (n lt 6);

  n + 1;

  end;

  run;

  Which one of the following is the value of the variable N in the output data set?

  A. 4
  B. 5
  C. 6
  D. 7
  C. 6

• Question 168:

  The following SAS program is submitted:

  libname rawdata1 'location of SAS data library';

  filename rawdata2 'location of raw data file';

  data work.testdata;

  infile

  input sales1 sales2;

  run;

  Which one of the following is needed to complete the program correctly?

  A. rawdata1
  B. rawdata2
  C. 'rawdata1'
  D. 'rawdata2'
  B. rawdata2

• Question 169:

  The following SAS program is submitted:

  data WORK.PRODUCTS;

  Prod=1;

  do while (Prod LE 7);

  Prod + 1;

  end;

  run;

  What is the value of the variable Prod in the output data set?

  A. 7
  B. 8
  C. 6
  D. .(missing numeric)
  B. 8

• Question 170:

  Given the raw data record in the file phone.txt:

  

  Which SAS statement completes the program and results in a value of "James Stevens" for the variableFullName?

  A. FullName=CATX(' ',EmpFName,EmpLName);
  B. FullName=CAT(' ',EmpFName,EmpLName);
  C. FullName=EmpFName!!EmpLName;
  D. FullName=EmpFName + EmpLName;
  A. FullName=CATX(' ',EmpFName,EmpLName);