SAS Institute SAS Institute Certifications A00-280 Questions & Answers

• Question 61:

  The following SAS program is submitted:

  

  Which types of variables are DayofMonth, MonthofYear, and Year?

  A. DayofMonth, Year, and MonthofYear are character.

  B. DayofMonth, Year, and MonthofYear are numeric.

  C. DayofMonth and Year are numeric. MonthofYear is character

  D. DayofMonth, Year, and MonthofYear are date values

  Correct Answer: B

• Question 62:

  Given the following partial output data set:

  

  Which code was used to create AGECAT?

  A. if age <18 then AGECAT=1; if 18<=AGE<=40 then AGECAT=2; else AGECAT=3;

  B. if age <=18 then do AGECAT=1; else if 18

  C. if age <18 then AGECAT=1; else if 18<=AGE<=40 then AGECAT=2; else AGECAT=3;

  D. if age <=18 then AGECAT=1; else if 18

  Correct Answer: D

• Question 63:

  Given the following entry in the SAS log:

  

  Which alternate method could you use to? ?Transpose all data ?Not produce a warning message in the log

  A. Use PROC TRANSPOSE with a WHERE clause to omit records with missing VISIT values

  B. Use PROC COPY with SELECT statements

  C. Use PROC DATASETS with SELECT and MODIFY statements

  D. Use a DATA step with conditional OUTPUT statements

  Correct Answer: D

• Question 64:

  Given the file sites.csv:

  

  Which option would you need to add to the INFILE statement to clear the notes from this log?

  A. firstobs=2

  B. missover

  C. lrecl=2

  D. start=2

  Correct Answer: A

• Question 65:

  Given the following data set DEMOG:

  

  Which selection below would be considered hard-coding?

  A. if sexcd eq 1 then sex = "Male" ; else if sexcd eq 2 then sex = "Female" ;

  B. if site eq 1 then sexcd = 2 ; else if site eq 2 then sexcd = 1 ;

  C. if site eq 1 and sexcd ne 2 then check = 1 ; else if site eq 2 and sexcd ne 1 then check = 2 ;

  D. birthdt = input(dob, mmddyy10.) ;

  Correct Answer: B

• Question 66:

  The following SAS program is submitted, but fails due to syntax errors.

  

  What is the cause of the syntax errors?

  A. The keep= data set option should be (keep=MonthExp*).

  B. An array can only be referenced in a KEEP statement and not within a keep= data set option.

  C. An array cannot be referenced on a keep= data set option.

  D. The keep= data set option should be (keep=MonthExp).

  Correct Answer: C

• Question 67:

  Given two data sets with the following variables:

  

  Why is the blue note showing in the log?

  A. The variable VISIT occurs in both data sets but is not included in the BY statement.

  B. There are no observations with matching values for SUBJID in either data set.

  C. There are multiple observations with the same value for SUBJID in both data sets.

  D. One of the two data sets has multiple observations with the same value for SUBJID.

  Correct Answer: C

• Question 68:

  The following SAS program is submitted:

  

  If the value for the variable Subjcode is "WGT2", what is the value of the variable Description?

  A. missing character value

  B. Unknown

  C. Over

  D. Wgt2

  Correct Answer: B

• Question 69:

  A SAS program is submitted and the following log is written.

  

  What is the cause of this error message?

  A. The ARRAY declaration is syntactically incorrect.

  B. The IF statement is syntactically incorrect.

  C. The DO loop tries to get a value from a variable which does not exist.

  D. The IF statement tries to get ARRAY elements which are not declared.

  Correct Answer: D

• Question 70:

  Which validation technique involves two programmers writing separate programs to produce the same output, then comparing the result?

  A. Independent Programming

  B. Peer Matching

  C. Identical Programming

  D. Peer Review

  Correct Answer: A