SAS Institute SAS Institute Certifications A00-201 Questions & Answers

• Question 71:

  The SAS data set EMPLOYEE_INFO is listed below:

  IDNUMBER Expenses 2542 100.00 3612 133.15

  2198 234.34

  2198 111.12

  The following SAS program is submitted:

  proc sort data = employee_info;

  run;

  Which one of the following BY statements completes the program and sorts the data sequentially by descending expense values within each descending IDNUMBER value?

  A. by descending IDNumber Expenses;

  B. by (IDNumber Expenses) descending;

  C. by IDNumber descending Expenses descending;

  D. by descending IDNumber descending Expenses;

  Correct Answer: D

• Question 72:

  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

  Correct Answer: B

• Question 73:

  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)

  Correct Answer: B

• Question 74:

  The following SAS program is submitted:

  proc print data = sasuser.houses;

  run;

  proc means data = sasuser.shoes;

  run;

  Which one of the following OPTIONS statements resets the page number to 1 for the second report?

  A. options pageno = 1;

  B. options pagenum = 1;

  C. options reset pageno = 1;

  D. options reset pagenum = 1;

  Correct Answer: C

• Question 75:

  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)

  Correct Answer: B

• Question 76:

  Unless specified, which variables and data values are used to calculate statistics in the MEANS procedure?

  A. non-missing numeric variable values only

  B. missing numeric variable values and non-missing numeric variable values only

  C. nun-missing character variables and nun-missing numeric variable values only

  D. missing character variables, nun-missing character variables, missing numeric variable values, and nun-missing numeric variable values

  Correct Answer: A

• Question 77:

  A raw data file is listed below:

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

  squash 1.10 apples 2.25 juice 1.69

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

  data groceries; infile `file-specification'; input item $ cost; run;

  Which one of the following completes the program and produces a grand total for all COST values?

  A. grandtot = sum cost;

  B. grandtot = sum(grandtot,cost);

  C. retain grandtot 0; grandtot = sum(grandtot,cost);

  D. grandtot = sum(grandtot,cost); output grandtot;

  Correct Answer: A

• Question 78:

  The following SAS program is submitted:

  proc report data = sasuser.houses nowd headline headskip; column style price;

  where price < 100000;

  title;

  run;

  Click the Exhibit button to view the output from the REPORT procedure.

  

  Assuming that the PRICE variable is numeric, which one of the following completes the program and produces the output displayed in the exhibit?

  A. define style / group `Style'; define price / mean `Price' format = dollar9.;

  B. define style / display `Style'; define price / across `Price' format = dollar9.;

  C. define style / display `Style'; define price / sum `Price' format = dollar9.;

  D. define style / order `Style'; define price / mean `Price' format = dollar9.;

  Correct Answer: C

• Question 79:

  The following SAS program is submitted:

  data work.new;

  mon = 3;

  day = 23;

  year = 2000;

  date = mdy(mon,day,year); run;

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

  A. a character string with the value `23mar2000'

  B. a character string with the value `03/23/2000'

  C. a numeric value of 14692, which represents the SAS date value for March 23, 2000

  D. a numeric value of 3232000, which represents the SAS date value for March 23, 2000

  Correct Answer: C

• Question 80:

  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;

  Correct Answer: D