SAS Training

SAS Certified Adv Programmer 130 Questions (43)

Which one of the following SAS integrity constraint types ensures that a specific set or range of values are the only values in a variable?

A. CHECK
B. UNIQUE
C. FORMAT
D. DISTINCT

SAS Certified Adv Programmer 130 Questions (42)

The following SAS program is submitted:

%macro test(var);
    %let jobs = BLACKSMITH WORDSMITH SWORDSMITH;
    %let type = %index(&jobs,&var);
%mend;

%test(SMITH)

Which one of the following is the resulting value of the macro variable TYPE?

A. 0
B. 3
C. 6
D. null

SAS Certified Adv Programmer 130 Questions (41)

Assume today is Tuesday, July 23, 2002. Which one of the following statements submitted at the beginning of a SAS session assigns the value Tuesday, July 23, 2002 to the macro variable START?

A. %let start = today(),weekdate.;
B. %let start = today(),format=weekdate.;
C. %let start = %sysfunc(today(),weekdate.);
D. %let start = %sysfunc(%today(),weekdate.);

SAS Certified Adv Programmer 130 Questions (40)

Given the following SAS data sets ONE and TWO:

ONE 
OBS COMMON X 
1   A      10
2   A      13
3   A      14
4   B      9
5   C      8
6   C      14

TWO 
OBS COMMON Y
1   A      1
2   A      3
3   B      4
4   B      2
5   C      5

The following SAS DATA step is submitted:

data combine;
    merge one two;
    by common;
run;

Which one of the following represents the data values stored in data set COMBINE?

A.

OBS COMMON X  Y 
1   A      10 1
2   A      13 3
3   A      14 3
4   B      9  4
5   B      9  2
6   C      8  5
7   C      14 5

B.

OBS COMMON X  Y
1   A      10 1
2   A      13 3
3   B      9  4
4   C      8  5

C.

OBS COMMON X  Y
1   A      10 1
2   A      13 3
3   B      14 4
4   B      9  2
5   C      8  5

D.

OBS COMMON X  Y
1   A      10 1
2   A      13 1
3   A      14 1
4   A      10 3
5   A      13 3
6   A      14 3
7   B      9  4
8   B      9  2
9   C      8  5
10  C      14 5 

SAS Certified Adv Programmer 130 Questions (39)

Which one of the following statements is true regarding a SAS DATA step view?

A. It allows write capabilities.
B. It contains global statements.
C. It contains data and a descriptor portion.
D. It contains a partially compiled DATA step.