SAS Institute SAS Institute Certifications A00-201 Questions & Answers

• Question 101:

  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,1810,4,3,Garris Street,"$107,250"

  RANCH,1 500 ,3,3,Kemble Avenue "$86,650"

  SPLIT, 1615,4,3 ,West Drive,"94,450"

  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' then

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

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

  A. 0

  B. 3

  C. 5

  D. 7

  Correct Answer: D

• Question 102:

  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 103:

  The following SAS program is submitted:

  data_null;

  set old;

  put sales 1 sales2;

  run;

  Where is the output written?

  A. the SAS log

  B. the raw data We that was opened last

  C. the SAS output window or an output file

  D. the data set mentioned in the DATA statement

  Correct Answer: A

• Question 104:

  When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:

  Iibname sasdata `SAS-data-Iibrary';

  options obs = 500;

  proc print data = sasdata.prdsales (firstobs = 100); run;

  options obs = max;

  proc means data = sasdata.prdsales (firstobs = 500); run;

  How many observations are processed by each procedure?

  A. 400 for PROC PRINT 4500 for PROC MEANS

  B. 401 for PROC PRINT 4501 for PROC MEANS

  C. 401 for PROC PRINT 4500 for PROC MEANS

  D. 500 for PROC PRINT 5000 for PROC MEANS

  Correct Answer: B

• Question 105:

  The following SAS program is submitted:

  proc means data = sasuser.shoes;

  where product in (`Sandal' , `Slipper' , `Boot');

  run;

  Which one of the following ODS statements completes the program and sends the report to an HTML file?

  A. ods html = `sales.html';

  B. ods file = `sales.html';

  C. ods file html = `sales.html';

  D. ods html file = `sales.html';

  Correct Answer: D

• Question 106:

  The following SAS program is submitted:

  Data_null;

  set old (keep = prod sales 1 sales2);

  file `file-specification';

  put sales1 sales2; run;

  Which one of the following default delimiters separates the fields in the raw data file created?

  A. : (colon)

  B. (space)

  C. , (comma)

  D. ; (semicolon)

  Correct Answer: B

• Question 107:

  The following SAS program is submitted:

  data allobs;

  set sasdata.origin (firstobs = 75 obs = 499);

  run;

  The SAS data set SASDATADRIGIN contains 1000 observations.

  How many observations does the ALLOBS data set contain?

  A. 424

  B. 425

  C. 499

  D. 1000

  Correct Answer: B

• Question 108:

  A raw data file is listed below:

  ----I----1 0---I----20---I----30

  John McCloskey 35 71

  June Rosesette 1043

  Tineke Jones 9 37

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

  data work.homework;

  infile `file-specification';

  input name $ age height

  if age LE 10;

  run;

  How many observations will the WORK.HOMEWORK data set contain?

  A. 0

  B. 2

  C. 3

  D. No data set is created as the program fails to execute due to errors.

  Correct Answer: C

• Question 109:

  The contents of the raw data file SIZE are listed below:

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

  72 95

  The following SAS program is submitted:

  data test;

  infile `size';

  input@1 height 2. @4 weight 2;

  run;

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

  A. 2

  B. 72

  C. 95

  D. . (missing numeric value)

  Correct Answer: A

• Question 110:

  The observations in the SAS data set WORK.TEST are ordered by the values of the variable SALARY.

  The following SAS program is submitted:

  proc sort data = work.test out = work.testsorted;

  by name;

  run;

  Which one of the following is the result of the SAS program?

  A. The data set WORKTEST is stored in ascending order by values of the NAME variable.

  B. The data set WORKTEST is stored in descending order by values of the NAME variable.

  C. The data set WORKTESTSORTED is stored in ascending order by values of the NAME variable.

  D. The data set WORKTESTSORTED is stored in descending order by values of the NAME variable.

  Correct Answer: C