SASInstitute SAS Institute Systems Certification A00-201 Questions & Answers

• Question 31:

  The following SAS program is submitted:

  data work.empsalary;

  set work.people (in = inemp)

  work.money (in = insal);

  if insal and inemp;

  run;

  The SAS data set WORK.PEOPLE has 5 observations, and the data set WORK.MONEY has 7 observations. How many observations will the data set WORKEMPSALARY contain?

  A. 0

  B. 5

  C. 7

  D. 12

  Correct Answer: A

• Question 32:

  The following SAS program is submitted:

  Iibname sasdata `SAS-data-library';

  data test;

  set sasdata.chemists;

  if jobcode = `Chem2'

  then description = `Senior Chemist';

  else description = `Unknown';

  run;

  A value for the variable JOBCODE is listed below:

  JOSCODE

  chem2

  Which one of the following values does the variable DESCRIPTION contain?

  A. Chem2

  B. Unknown

  C. Senior Chemist

  D. ` ` (missing character value)

  Correct Answer: B

• Question 33:

  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.

  Correct Answer: B

• Question 34:

  The contents of the SAS data set named PEPM.STUDENTS are listed below:

  name age

  Alfred 14

  Alice 13

  Barbaba 13

  Carol 14

  The following SAS program is submitted using the PERM STUDENTS data set as input libname perm `SAS-data-library';

  data students;

  set perm.students;

  file `file-specification';

  put name $15. @5 age 2.; run;

  Which one of the following represents the values written to the output raw data file?

  A. ----I----10---I----20---I----30 Alfred 14 Alice 13 Barbara 13 Carol 14

  B. ----I----10---I----20---I----30 AIfr14 Alicl3 Barb 13a Carol 4

  C. ----I----10---I----20---I----30 Alfr14ed Alicl3e Barb l3ara Carol4l

  D. ----I----10---I----20---I----30----I----10---I----20---I----30 Alfred 14 Alice 13 Barbara 13 Carol 14

  Correct Answer: B

• Question 35:

  Click the Exhibit button to view two reports.

  

  Assume permanent variable labels have been assigned. The following SAS program is submitted and produces the first report:

  proc report data = sasuser.shoes nowd; column region subsidiary sales; define subsidiary / display; define region / group; define sales / sum;

  Which one of the following corrects the program above to produce the second report shown in the exhibit?

  A. Define the variable SUBSIDIARY with a SUM usage.

  B. Define the variable SUBSIDIARY with a GROUP usage.

  C. Define the variable SUBSIDIARY with an ORDER usage.

  D. Define the variable SUBSIDIARY with an ACROSS usage.

  Correct Answer: B

• Question 36:

  The following SAS program is submitted:

  data work.sets;

  do until (prod gt 6);

  prod + 1;

  end;

  run;

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

  A. 5

  B. 6

  C. 7

  D. 6

  Correct Answer: C

• Question 37:

  Which one of the following ODS statement options terminates output being written to an HTML file?

  A. END

  B. QUIT

  C. STOP

  D. CLOSE

  Correct Answer: D

• Question 38:

  The following SAS program is submitted:

  proc datasets lib = sasuser; contents data = class varnum; quit;

  Which one of the following is the purpose of the VARNUM option?

  A. to print a list of variable names

  B. to print the total number of variables

  C. to print a list of the variables in alphabetic order

  D. to print a list of the variables in the order they were created

  Correct Answer: D

• Question 39:

  The following SAS program is submitted:

  data work.products;

  Product_Number = 5461;

  Item = `1001';

  Item_Reference = ltem||'/'IlProduct_Number; run;

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

  A. 1001/5461

  B. 1001/ 5461

  C. . (missing numeric value)

  D. The value can not be determined as the program fails to execute due to errors.

  Correct Answer: B

• Question 40:

  The following SAS program is submitted:

  footnote1 `Sales Report for Last Month';

  footnote2 `Selected Products Only';

  footnote3 `All Regions';

  footnote4 `All Figures in Thousands of Dollars';

  proc print data = sasuser.shoes;

  footnote2 `All Products';

  run;

  Which one of the following contains the footnote text that is displayed in the report?

  A. All Products

  B. Sales Report for Last Month All Products

  C. All Products All Regions All Figures in Thousands of Dollars

  D. Sales Report for Last Month All Products All Regions All Figures in Thousands of Dollars

  Correct Answer: B