Base SAS Certification Sample Question 16.1

I hope the below Base SAS Certification sample question is helpful to you when you're studying for the exam. Leave your answer as a comment below and good luck!

-SAS Cert

************************


Which of the following is standard data that may be read with either column input or formatted input?

a) $1000
b) 10/3/2012
c) 10%
d) -1.54E-3

Base SAS Certification Sample Question 15.1

I hope the below Base SAS Certification sample question is helpful to you when you're studying for the exam. Leave your answer as a comment below and good luck!

-SAS Cert

******************************


Which of the following is an invalid way to list array elements?

a) _NUMERIC_
b) _CHARACTER_
c) _ALL_
d) None of the above

Base SAS Certification Sample Question 14.1

I hope the below Base SAS Certification sample question is helpful to you when you're studying for the exam. Leave your answer as a comment below and good luck!

-SAS Cert

*******************************

How many variables/observations will come from the below program?


data work.roth_ira;
     start = 1000;
     do year = 1 to 30;
          savings + 5000;
          do month = 1 to 12;
               int = savings * (.05/12);
               savings + int;
          end;
          output;
     end;
run;


a) 4 variables, 12 observations
b) 4 variables, 30 observations
c) 5 variables, 12 observations
d) 5 variables, 30 observations

Free Base SAS Certification Study Notes

Hi everyone,

I wanted to give you all a heads up that I'll be posting free Base SAS Certification study notes from time to time at the link below. Feel free to check these out as you're studying for the Base SAS Certification exam.

http://sascert3.blogspot.com/p/products.html


In addition, a complete list of my Base SAS Certification example questions can be found at the below link. These questions will give you a good benchmark of where you stand before you sit for the exam and what your strengths and weaknesses are.

http://sascert3.blogspot.com/search/label/Base%20SAS%20Example%20Questions


I hope these Base SAS Certification study notes and questions are useful to you, and please be sure to leave comments if there are other topics or example questions that you would include or leave out.

Good luck studying!

-SAS Cert

Base SAS Certification Sample Question 13.1

I hope the below Base SAS Certification sample question is helpful to you when you're studying for the exam. Leave your answer as a comment below and good luck!

-SAS Cert


*********************************


Assume the variable employee_id in the ecsql1.salesstaff table has a length of 8, and the program below runs without errors. Which of the below statements is true about the variable employee_id2?


data work.sales_id (keep=employee_id2);
    set ecsql1.salesstaff (keep=employee_id);
    employee_id2 = put(employee_id,$9.);
run;


a) employee_id2 is a numeric variable with length 8
b) employee_id2 is a numeric variable with length 9
c) employee_id2 is a character variable with length 8
d) employee_id2 is a character variable with length 9

Base SAS Certification Sample Question 12.1

I hope the below Base SAS Certification sample question is helpful to you when you're studying for the exam. Leave your answer as a comment below and good luck!

-SAS Cert


*****************************


Which of the following is false about one-to-one merging?

a) The new dataset contains all variables from all input data sets
b) If there are same-named variables, the last dataset's variable replaces the earlier dataset's variable
c) The new dataset contains the total number of observations in the smallest original dataset
d) None of the above

Base SAS Certification Sample Question 11.1

I hope the below Base SAS Certification sample question is helpful when you're studying for the exam. Leave your answer as a comment below and good luck!

-SAS Cert

******************************


What should the blank line below read to be able to output the sum of Qtr_total by the variable paid_by?


proc sort data=ecsql1.employee_donations out=work.employee_donations_sort;
    by paid_by;
run;


data work.donations (keep=paid_by Qtr_total);
    set work.employee_donations_sort;
    by paid_by;
    Qtr_total + Qtr1;
    if _____________;
run;


a) last paid_by
b) paid_by.last
c) paid_by.last = 1
d) last.paid_by = 1

Base SAS Certification Example Question 10.1

Assume ecsql1.employee_donations has 6 observations, and qtr1 has 6 values listed below:

100
200
300
.
150
50


What is the value of donation_tot after the 5th DATA step iteration?


data work.donations;
     set ecsql1.employee_donations (drop=qtr2-qtr4);
     retain donation_tot 1000;
     donation_tot + qtr1;
run;


a) 0
b) 750
c) 1750
d) Data step fails due to errors


*******************************************

Leave your answers as a comment below...good luck!

-SAS Cert

Base SAS Certification Example Question 9.1

Which is false about the BODY, CONTENTS, and FRAME specifications when creating an HTML file?


a) BODY is the name of an HTML file that contains the procedure output
b) FRAME is the name of an HTML file that integrates the table of contents and the body file
c) If you specify FRAME=, you must also specify CONTENTS=
d) None of the above


******************************************

Leave your answer to this Base SAS Certification example question as a comment below...good luck!

-SAS Cert

Base SAS Certification Example Question 8.1

By default, PROC MEANS computes how many of the below statistics?

Standard deviation
Range
Count
Minimum value
Variance
Mode

a) 2
b) 3
c) 4
d) None of the above

******************

PROC MEANS, PROC FREQ, and PROC SUMMARY procedures are a big part of the Base SAS exam, and if you can answer these questions correctly you'll be well on your way to achieving your certification! Be sure to leave your answer as a comment below and good luck!

-SAS Cert

Base SAS Example Question 7.1

Which of the following is a valid statement about the VALUE range in the PROC FORMAT procedure? It cannot be...

a) A single character or numeric value
b) A range of character values
c) A list of unique values separated by commas
d) A combination of character and numeric values


****************

Leave your answer below...good luck!

-SAS Cert

Base SAS Example Question 6.1

dta work.il_corn;
    set corn.state_data;
    if state = 'Illinois';
run;


The keyword "data" is misspelled above. What happens to this program during the compilation phase assuming "corn" is a valid libref?


a) The program fails due to syntax errors
b) The DATA step compiles but doesn't execute
c) The DATA step compiles and executes
d) None of the above

************************

Leave your answer as a comment below...good luck!

-SAS Cert

Base SAS Example Question 5.1

Fill in the blank to output the first 5 observations from the filename col_inp.


data work.column_file;
     infile col_inp _____;
     input id 1 Name $ 3-16 Address $ 18-35;
     where Name contains 'Ziggy';
run;


a) maxobs=5
b) obs=5
c) datalines=5
d) lines=5


Leave your answer as a comment below...good luck!

SAS Cert

Base SAS Example Question 4.1

Leave your answer in the comments below...good luck!

-SAS Cert

_________________________

Assume the variable 'Unit_Cost_Price' (numeric) contains both missing and non missing values. What would the below output contain?

proc sort data=ecsql1.price_list;
 by Unit_Cost_Price;
run;

a) A new dataset work.price_list is created with Unit_Cost_Price sorted in ascending order with missing values at the bottom of the dataset
b) The dataset ecsql1.price_list is sorted with Unit_Cost_Price sorted in descending order with missing values at the bottom of the dataset
c) A new dataset work.price_list is created with Unit_Cost_Price sorted in descending order with missing values at the top of the dataset
d) The dataset ecsql1.price_list is sorted with Unit_Cost_Price sorted in ascending order with missing values at the top of the dataset

Base SAS Example Question 3.1

Anyone know the answer to the below question? Leave your answer as a comment, and I'll post the solution once we get at least 3 responses.

Remember, all these example questions I post are similar to questions that would appear on the Base SAS Certification exam. If you can answer these correctly, you can crack the questions on test day!

Good luck!
SAS Cert

-------------------------------------------------

Which of the below lines opens an external SAS file?

a) include 'd:\programs\sas\newprog.sas'
b) include 'd:\programs\sas\newprog.sas';
c) file 'd:\programs\sas\newprog.sas'
d) file 'd:\programs\sas\newprog.sas';

Base SAS Example Question 2.1

Be sure to leave a comment to the free Base SAS exam question listed below. I'll post the solution in a week or two. Good luck!

-SAS Cert

---------------------------------------------

What keyword should be used in the blank below to list the dataset's variables in logical, not alphabetical order?

proc contents data=air.organics ___;
run;

a) log
b) logical
c) varnum
d) var

Base SAS Example Question 1.1

Hi everyone,

I'm going to start posting example questions for the Base SAS exam about once a week. The questions will test information covered in the SAS Certification Prep Guide, and I'll provide the answers to these questions about a week or two after they're originally posted.

Please leave a comment below this post with your answer - hopefully this will start a good discussion from fellow SAS programmers who are studying for the Base SAS Certification.

Good luck!
SAS Cert

-----------------------------------------
 
How many of the below variable names will not produce errors in an assignment statement?


variable
var
1variable
var1
#var
_variable#


a) 0
b) 1
c) 3
d) 6