SAS Institute A00-201 Online Practice Questions and Exam Preparation

SAS Institute A00-201 Online Questions & Answers

• Question 71:

  The following SAS program is submitted:

  data work.staff; JobCategory' = `FA'; JobLevel = `1';

  JobCategory = JobCategory || JobLevel; run;

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

  A. FA
  B. FA1
  C. FA1
  D. ``(missing character value)
  A. FA

• Question 72:

  The following SAS DATA step is submitted:

  data work.accounting; set work.department; length jobcode $ 12; run;

  The WORK.DEPARTMENT SAS data set contains a character variable named JOSCODE with a length of 5.

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

  A. 5
  B. 8
  C. 12
  D. The length can not be determined as the program fails to execute due to errors.
  A. 5

• Question 73:

  A raw data file is listed below:

  RANCH,1250,2,1 ,Sheppard Avenue,"$64.000" SPLIT,1,190,1,1,Rand Street,"$65,850" CONDO,1400,2,1.5,Market Street,"80,050" TWOSTORY,18104,3,Garris Street,"$107,250" RANCH,1500,3,3,Kemble Avenue,"$86,650" SPLIT,1615A,3,West Drive,"94,A50" SPLIT,1305,3,1.5,Graham Avenue,"$73,650"

  The following SAS program is submitted using the raw data file as input:

  data work.condo_ranch; infile `file-specification' dsd;

  input style $ @;

  if style = `CONDO' or style = `RANCH';

  input sqfeet bedrooms baths street $ price : dollar10.; run;

  How many observations will the output data set contain?

• Question 74:

  The following SAS DATA step executes on Monday, April 25, 2000:

  data newstaff;

  set staff;

  start_date = today();

  run;

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

  A. a character string with the value `04/25/2000'
  B. a character string with the value `Monday, April 25, 2000'
  C. the numeric value 14725, representing the SAS date for April 25, 2000
  D. the numeric value 04252000, representing the SAS date for April 25, 2000
  C. the numeric value 14725, representing the SAS date for April 25, 2000

• Question 75:

  The following SAS program is submitted:

  data work.passengers;

  if OrigPassengers = then

  OrigPassengers = 100;

  TransPassengers = 100;

  OrigPassengers = .;

  NonPaying = 10;

  TotalPassengers = sum (OrigPassengers, TransPassengers); run;

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

  A. 100
  B. 110
  C. 200
  D. (missing numeric value)
  B. 110

• Question 76:

  The SASDATA.BANKS data set has five observations when the following SAS program is submitted; libname sasdata `SAS-data-library';

  data allobs;

  set sasdata.banks;

  capitaI=0;

  do year = 2000 to 2020 by 5;

  capital + ((capital+2000) * rate);

  output;

  end;

  run;

  How many observations will the ALLOBS data set contain?

  A. 5
  B. 15
  C. 20
  D. 25
  D. 25

• Question 77:

  The following SAS program is submitted:

  libname temp `SAS-data-library';

  data work.new;

  set temp.jobs;

  format newdate mmddyy10.;

  qdate = qtr(newdate);

  ddate = weekday(newdate);

  run;

  proc print data = work.new;

  run;

  The variable NEWDATE contains the SAS date value for April 15, 2000.

  What output is produced if April 15, 2000 falls on a Saturday?

  A. Obs newdate qdate ddate 1 APR152000 2 6
  B. Obs newdate qdate ddate 1 04/15/2000 2 6
  C. Obs newdate qdate ddate 1 APP152000 2 7
  D. Obs newdate qdate ddate 1 04/15/2000 2 7
  D. Obs newdate qdate ddate 1 04/15/2000 2 7

• Question 78:

  Which one of the following is true when SAS encounters a data error in a DATA step?

  A. The DATA step stops executing at the point of the error, and no SAS data set is created.
  B. A note is written to the SAS log explaining the error, and the DATA step continues to execute.
  C. A note appears in the SAS log that the incorrect data record was saved to a separate SAS file for further examination.
  D. The DATA step stops executing at the point of the error, and the resulting DATA set contains observations up to that point.
  B. A note is written to the SAS log explaining the error, and the DATA step continues to execute.

• Question 79:

  Which one of the following SAS DATA steps saves the temporary data set named MYDATA as a permanent data set?

  A. libname sasdata `SAS-data-Iibrary';data sasdata.mydata; copy mydata; run;
  B. libname sasdata `SAS-data-Iibrary'; data sasdata.mydata; keep mydata; run;
  C. libname sasdata `SAS-data-Iibrary'; data sasdata.mydata; save mydata; run;
  D. libname sasdata `SAS-data-Iibrary'; data sasdata.mydata; set mydata; run;
  D. libname sasdata `SAS-data-Iibrary'; data sasdata.mydata; set mydata; run;

• Question 80:

  The SAS data set BANKS is listed below:

  The following SAS program is submitted:

  data newbank;

  do year = 1 to 3;

  set banks;

  capital + 5000;

  end;

  run;

  Which one of the following represents how many observations and variables will exist in the SAS data set NEWBANK?

  

  A. 0 observations and 0 variables
  B. 1 observations and 4 variables
  C. 3 observations and 3 variables
  D. 9 observations and 2 variables
  B. 1 observations and 4 variables