Monday, June 17, 2013

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

Monday, June 10, 2013

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

Sunday, June 2, 2013

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

Saturday, May 25, 2013

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

Sunday, May 19, 2013

SAS Proc Contents

Below is a summary of the SAS Proc Contents procedure. You can pretty much guarantee that the Proc Contents procedure topic will show up somewhere on the Base SAS Certification exam, so be sure to read and understand this information thoroughly. It's an easy correct answer on the exam if you do!


Proc Contents Purpose:
Describes the contents of a library or the descriptor information for an individual SAS data set


Syntax:

PROC CONTENTS DATA=sas-data-library-or-data-set  (NODS) (VARNUM);
RUN;

***NODS and VARNUM are optional and their uses are described below


Other Important Points Worth Mentioning:
You can specify _ALL_ after a libref to show a detailed listing of all the files in the library

Example:
proc contents data=credit._all_;
run;


You can specify NODS to suppress detailed information about each file. You can only use this option when libref._ALL_ is specified.

In the example below, there are 3 datasets in the SAS library air - Organics, Reten7, and Scoredata.

Example:
proc contents data=air._all_ nods;
run;





The VARNUM option is used to list the variable names in their logical position (creation order) as opposed to alphabetical order.

Example:
proc contents data=credit.mortgage varnum;
run;


I hope this was helpful for you. Let me know what you think in the comments section and good luck studying!

-SAS Cert

Wednesday, May 8, 2013

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

Wednesday, May 1, 2013

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