SASInstitute SAS Institute Systems Certification A00-201 Questions & Answers

• Question 21:

  On which portion(s) of a SAS data set does the PRINT procedure report?

  A. the data portion only

  B. the descriptor portion only

  C. the descriptor portion and the data portion

  D. neither the data portion nor the descriptor portion

  Correct Answer: A

• Question 22:

  The following SAS program is submitted:

  data numrecords;

  mule `file-specification';

  mnput@1 patient $15.

  relative$ 16-26@;

  if relative = `children' then

  input @54 diagnosis $15. @;

  else if relative = `parents' then

  input @28 doctor $15.

  clinic $ 44-53

  @54 diagnosis $15. @;

  input age;

  run;

  How many raw data records are read during each iteration of the DATA step during execution?

  A. 1

  B. 2

  C. 3

  D. 4

  Correct Answer: A

• Question 23:

  The following SAS program is submitted:

  data work.test;

  First = `lpswich, England';

  City_Country = substr(First,1,7)!!', `!!`England'; run;

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

  A. 6

  B. 7

  C. 17

  D. 25

  Correct Answer: D

• Question 24:

  The following SAS program is submitted:

  data work.january;

  set work.allmonths (keep = product month num_sold cost); if month = `Jan' then output work.january

  sales = cost * num_sold;

  keep = product sales;

  run;

  Which variables does the WORK.JANUARY data set contain?

  A. PRODUCT and SALES only

  B. PRODUCT, MONTH, NUM_SOLD and COST only

  C. PRODUCT, SALES, MONTH, NUM_SOLD and COST only

  D. An incomplete output data set is created due to syntax errors.

  Correct Answer: D

• Question 25:

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

  libname sasdata `SAS-data-library';

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

  A raw data record is listed below:

  ----I----10---I----20---I----30 1999/10/25

  The following SAS program is submitted:

  data projectduration; infile `file-specification'; input date$ 1- 10; run;

  Which one of the following statements completes the program above and computes the duration of the project in days as of today's date?

  duration = today( ) - put(date,ddmmyy10.); duration = today( ) - put(date,yymmdd10.); duration = today( ) - input(date,ddmmyy10.); duration = today( ) - input(date,yymmdd10.);

  A.

  B.

  C.

  D.

  Correct Answer:

• Question 27:

  In the following SAS program, the input data files are sorted by the NAMES variable:

  libname temp SAS-data-library';

  data temp.sales;

  merge temp.sales

  work.receipt;

  by names;

  run;

  Which one of the following results occurs when this program is submitted?

  A. The program executes successfully and a temporary SAS data set is created.

  B. The program executes successfully and a permanent SAS data set is created.

  C. The program fails execution because the same SAS data set is referenced for both read and write operations.

  D. The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.

  Correct Answer: B

• Question 28:

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

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

  24613 $25.31

  The following SAS program is submitted:

  data inventory; infile `product'; input idnum 5. @10 price; run;

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

  A. 25.31

  B. $25.31

  C. . (missing numeric value)

  D. No value is stored as the program fails to execute due to errors.

  Correct Answer: C

• Question 29:

  The following SAS program is submitted:

  data revenue; set year_1; var1 = mdy(1,15,i960); run;

  Which one of the following values does the variable named VAR1 contain?

  A. 14

  B. 15

  C. 1151960

  D. `1/15/1960'

  Correct Answer: A

• Question 30:

  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?

  A.

  B.

  C.

  D.

  Correct Answer: