• support.sas.com
• KNOWLEDGE BASE
• SUPPORT
• LEARNING CENTER
• COMMUNITY

Learning Center

• Bookstore
• Training
• Certification
  • Exams and Preparation
  • Exam Registration
  • Directory
  • Discounts
  • Frequently Asked Questions
  • Certification Community
• SAS Learning Edition
• SAS Global Academic Program
• SAS OnDemand

Sample Questions

The following examples of multiple choice questions have been provided to illustrate some of the various types of questions that may appear on the SAS Global Certification Program exams.

Please note: These examples are not inclusive and do not necessarily represent all of the types of questions that comprise the exams. The questions below are not designed to assess an individual's readiness to take a certification exam.

• SAS Base Programming for SAS 9
• SAS Advanced Programming for SAS 9
• Predictive Modeling Using SAS Enterprise Miner 5 Exam

SAS Base Programming for SAS 9

Item 1

The following program is submitted.

data test;
   input name $ age;
cards;
John +35
;
run;

Which values are stored in the output data set?

1. name              age
   ---------------------
   John               35 

2. name              age
   ---------------------
   John              (missing value)

3. name              age
   ---------------------
   (missing value)   (missing value)

4. The DATA step fails execution due to data errors.

correct_answer = "A"

Item 2

The following observation is stored in a SAS data set named EMPLOYEES:

LNAME         FNAME       JOBCODE
---------------------------------
Whitley       Sam         na1       

If the DATA step below is executed, what will be the value of the variable JOBDESC in the output SAS data set when this observation is processed:

data navigate;
  set employees;
  if jobcode = 'NA1' then jobdesc = 'Navigator';
run;

1. navigator
2. Navigator
3. NAVIGATOR
4. a missing value

correct_answer = "D"

Item 3

The following SAS program is submitted:

 
proc format;
   value score  1  - 50  = 'Fail'
               51 - 100  = 'Pass';
run;

Which one of the following PRINT procedure steps correctly applies the format?

1. proc print data = sasuser.class;
      var test;
      format test score;
   run;

2. proc print data = sasuser.class;
      var test;
      format test score.;
   run;

3. proc print data = sasuser.class format = score;
      var test;
   run;

4. proc print data = sasuser.class format = score.;
      var test;  
   run;

correct_answer = "B"

Item 4

Given the following DATA step:

data loop;
  x = 0;
  do index = 1 to 5  by  2;
  x = index ;
  end;
run;

Upon completion of execution, what are the values of the variables X and INDEX in the SAS data set named LOOP?

1. x = 3, index = 3
2. x = 3, index = 4
3. x = 5, index = 5
4. x = 5, index = 6
5. x = 5, index = 7

correct_answer = "E"

Item 5

Given that the data set named ONE contains 10 observations and the data set named TWO contains 10 observations, how many observations will be contained in the data set named COMBINE that is created in the following DATA step?

data combine;
  set one two;
run;

1. 10
2. 20
3. 0, the DATA step will fail due to syntax errors
4. 10 to 20, depending on how many observations match

correct_answer = "B"

SAS Advanced Programming for SAS 9

Item 1

Given the following SAS data sets ONE and TWO:

The following SAS program is submitted:

proc sql;
   select one.*, sales
         from one right join two
         on one.year = two.year;
quit;

Which one of the following reports is generated?

1. 
2. 
3. 
4. 

correct_answer = "D"

Item 2

Given the following SAS data sets ONE and TWO:

The following SAS program is submitted creating the output table THREE:

data three;
merge one (in = in1) two (in = in2);
   by num;
run;

Which one of the following SQL programs creates an equivalent SAS data set THREE?

1. proc sql;
   create table three as
      select *
         from one full join two
         where one.num = two.num;
   quit;
   

2. proc sql;
   create table three as
      select coalesce(one.num, two.num)
         as NUM, char1, char2
         from one full join two
         where one.num = two.num;
   quit;

3. proc sql;
   create table three as
      select one.num, char1, char2
         from one full join two
         on one.num = two.num;
   quit;

4. proc sql;
   create table three as
      select coalesce(one.num, two.num) 
         as NUM, char1, char2
         from one full join two
         on one.num = two.num;
   quit;

correct_answer = "D"

Item 3

The following SAS program is submitted:

%let type = RANCH;
proc sql;
  create view houses as
  select * 
  from sasuser.houses
  where style = "&type";
quit;

%let type = CONDO;

proc print data = houses;
run;

The report that is produced displays observations whose value of STYLE are all equal to RANCH.

Which one of the following functions on the WHERE clause resolves the current value of the macro variable TYPE?

1. GET
2. SYMGET
3. %SYMGET
4. &RETRIEVE

correct_answer = "B"

Item 4

The SAS data set SASDATA.SALES has a simple index on the variable DATE and a variable named REVENUE with no index.

In which one of the following SAS programs is the DATE index considered for use?

1. proc print data = sasdata.sales;
      by date;
   run;

2. proc print data = sasdata.sales;
      where month(date) = 3;
   run;

3. data march;
      set sasdata.sales;
      if '01mar2002'd < date < '31mar2002'd;
   run;

4. data march;
      set sasdata.sales;
      where date < '31mar2002'd or revenue > 50000;
   run;

correct_answer = "A"

Predictive Modeling Using SAS Enterprise Miner 5 Exam

Item 1

Open the diagram labeled Practice A within the project labeled Practice A. Perform the following in SAS Enterprise Miner 5.2:

1. Set the Clustering method to Average.
2. Run the Cluster node.

Use this project to answer the next two questions:

What is the Importance statistic for MTGBal (Mortgage Balance)?

1. 0.32959
2. 0.42541
3. 0.42667
4. 1.000000

correct_answer = "C" You must change the clustering method to average and run the cluster node first. Select view results and look in the output window and view the Variable Importance results.

What is the Cubic Clustering Criterion statistic for this clustering?

1. 5.00
2. 14.69
3. 5862.76
4. 67409.93

correct_answer = "B" Run the diagram flow and view the results. From the results window, select View -> Summary Statistics -> CCC Plot and mouse over where the data point and the line intersect. This will display the CCC statistic.

Item 2

1. Create a project named Insurance, with a diagram named Explore.
2. Create the data source, DEVELOP, in SAS Enterprise Miner 5.2. DEVELOP is in the directory c:\workshop\Practice.
3. Set the role of all variables to Input, with the exception of the Target variable, Ins (1= has insurance, 0= does not have insurance).
4. Set the measurement level for the Target variable, Ins, to Binary.
5. Ensure that Branch and Res are the only variables with the measurement level of Nominal.
6. All other variables should be set to Interval or Binary.
7. Make sure that the default sampling method is random and that the seed is 12345.

Use this project to answer the next questions. (Note: only 2 of 7 questions are displayed for this example)

The variable Branch has how many levels?

1. 8
2. 12
3. 19
4. 47

correct_answer = "C" This information can be obtained by viewing the PROC FREQ output.

What is the mean credit card balance (CCBal) of the customers with a variable annuity?

1. $0.00
2. $8,711.65
3. $9,586.55
4. $11,142.45

correct_answer = "D" You can use a Stat Explore Node and view the output for the Descriptive Statistics for CCBal by level of the target variable.

Contact Us | Sitemap | RSS Feeds | www.sas.com | Terms of Use & Legal Information | Privacy Statement