SAS Institute A00-211 Online Practice Questions and Exam Preparation

SAS Institute A00-211 Online Questions & Answers

• Question 51:

  The SAS data set Fed.Banks contains a variable Open_Date which has been assigned a permanent label of "Open Date". Which SAS program temporarily replaces the label "Open Date" with the label "Starting Date" in the output?

  A. proc print data=SASUSER.HOUSES label; label Open_Date "Starting Date"; run;
  B. proc print data=SASUSER.HOUSES label; label Open_Date="Starting Date"; run;
  C. proc print data=SASUSER.HOUSES; label Open_Date="Starting Date"; run;
  D. proc print data=SASUSER.HOUSES; Open_Date="Starting Date"; run;
  B. proc print data=SASUSER.HOUSES label; label Open_Date="Starting Date"; run;

• Question 52:

  The following SAS program is submitted:

  proc contents data = sasuser.airplanes; run;

  Which one of the following is produced as output?

  A. the data portion of every data set in the SASUSER library
  B. the data portion of the data set SASUSER.AIRPLANES only
  C. the descriptor portion of every data set in the SASUSER library
  D. the descriptor portion of the data set SASUSER.AIRPLANES only
  D. the descriptor portion of the data set SASUSER.AIRPLANES only

• Question 53:

  A SAS program is submitted and the following SAS log is produced:

  2 data gt100;

  3 set ia.airplanes

  4 if mpg gt 100 then output;

  22 202

  ERROR: File WORK.IF.DATA does not exist.

  ERROR: File WORK.MPG.DATA does not exist.

  ERROR: File WORK.GT.DATA does not exist.

  ERROR: File WORK.THEN.DATA does not exist.

  ERROR: File WORK.OUTPUT.DATA does not exist.

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

  a quoted string, (, ;, END, KEY, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.

  ERROR 202-322: The option or parameter is not recognized and will be ignored.

  5 run;

  The IA libref was previously assigned in this SAS session.

  Which one of the following corrects the errors in the LOG?

  A. Delete the word THEN on the IF statement.
  B. Add a semicolon at the end of the SET statement.
  C. Place quotes around the value on the IF statement.
  D. Add an END statement to conclude the IF statement
  B. Add a semicolon at the end of the SET statement.

• Question 54:

  Read the table:

  

  Given the SAS data set SASUSER.HOUSES:

  Obs style bedrooms baths price sqteet street

  1 CONDO 2 1.5 80050 1200 MAIN

  2 CONDO 3 2.5 79350 1300 ELM

  3 CONDO 4 2.5 127150 1400 OAK

  4 CONDO 2 2.0 110700 1100 FIFTH

  5 TWOSTORY 4 3.0 107250 2100 SECOND

  6 TWOSTORY 2 1.0 55650 1600 WEST

  7 TWOSTORY 2 1.0 69250 1450 NORTH

  6 TWOSTORY 4 2.5 102950 2000 SOUTH

  The following SAS program is submitted:

  proc report data = sasuser.houses nowd headline;

  column style price;

  where price It 100000;

  define price / mean width = 9 format = dollar12.;

  title;

  run;

  The following output is desired:

  style price

  CONDO $79,700 TWOSTORY $62550

  Which DEFINE statement completes the program and produces the desired output?

  A. define style / width = 9,
  B. define style / orderwidth = 9;
  C. define style / group width = 9;
  D. define style / display width = 9;
  C. define style / group width = 9;

• Question 55:

  The Excel workbook REGIONS.XLSX contains the following four worksheets:

  EAST WEST NORTH SOUTH

  The following program is submitted: libname MYXLS pcfiles path='c:\regions.xlsx';

  Which PROC PRINT step correctly displays the NORTH worksheet?

  A. proc print data=MYXLS.NORTH.XLS; run;
  B. proc print data=MYXLS.'NORTH$'n; run;
  C. proc print data=MYXLS.NORTH$; run;
  D. proc print data=MYXLS.'NORTH'e; run;
  B. proc print data=MYXLS.'NORTH$'n; run;

• Question 56:

  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.
  C. 7

• Question 57:

  The following SAS program is submitted:

  data work.accounting;

  set work.department;

  length jobcode $ 12;

  jobcode='FAl';

  run;

  The WORK.DEPARTMENT data set contains a character variable named JOBCODE with a length of 5. What is the result?

  A. The length of the variable JOBCODE is 3.
  B. The length of the variable JOBCODE is 5.
  C. The length of the variable JOSBODE is 12.
  D. The program fails to execute due to errors.
  B. The length of the variable JOBCODE is 5.

• Question 58:

  The following SAS program is submitted:

  data work.new;

  length word $7;

  amount = 7;

  if amount = 5 then word = 'CAT';

  else if amount = 7 then word = 'DOG';

  else word = 'NONE!!!';

  amount = 5;

  run;

  Which one of the following represents the values of the AMOUNT and WORD variables?

  A. amount word 5 DOG
  B. amount word 5 CAT
  C. amount word 7 DOG
  D. amount word 7 ' ' (missing character value)
  A. amount word 5 DOG

• Question 59:

  The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7.; The following SAS program is submitted:

  

  What are the formats of the variables LocalFee and CountryFee in the output data set?

  A. LocalFee has format of 9. and CountryFee has a format of percent7.2
  B. LocalFee has format of 9. and CountryFee has a format of 7.
  C. Both LocalFee and CountryFee have a format of percent7.2
  D. The data step fails execution; there is no format for LocalFee.
  C. Both LocalFee and CountryFee have a format of percent7.2

• Question 60:

  The following SAS program is submitted:

  data test;

  infile `file specification';

  input name $ amount@@;

  run;

  Which of the following is true?

  A. Two @@ together are the same as one c.
  B. Two @@ hold the data records until the bottom of the DATA step.
  C. Two @@ hold the raw data record across iterations of the DATA step.
  D. Two @@ are invalid syntax and will cause the program to fail to execute.
  C. Two @@ hold the raw data record across iterations of the DATA step.