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 17, 2013
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
-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
-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
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
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
-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
-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
Wednesday, April 24, 2013
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
-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
Saturday, April 20, 2013
Becoming Base SAS Certified Tip #2 - Buy the Practice Test
Hi everyone,
To elaborate on my 2nd point in the before blog post, it's very important to buy the Base SAS Certification practice test. This practice test will give you a great benchmark of what your strong and weak areas are and how your should structure the rest of your studying prior to exam day.
You can purchase the practice test from the SAS Institute for $55 at the link below:
https://support.sas.com/edu/schedules.html?ctry=us&id=851
The practice exam is very similar to the actual Base SAS Certification for SAS 9 exam, but there are a few key differences that you should be aware of:
Number of Questions:
The practice exam has 50 questions, while the actual Base SAS Certification exam has 64 questions. Because the practice exam has fewer questions, the SAS Institute recommends that you use 85 minutes to take the practice exam (vs. 110 minutes on the actual exam).
Exam Format:
The practice exam is delivered on one continuous HTML screen. In contrast, the actual Base SAS Certification exam displays only one question on the screen at a time. You are also able to flag questions on the actual exam and return to them later...but you can't do this on the practice exam.
Keeping Time:
There is a timer displayed on the actual Base SAS Certification exam, but this isn't available on the practice exam.
In addition, the SAS Institute claims that the percentage of question topics on the practice exam match the question weights on the actual Base SAS Certification exam. When I finished taking the practice exam, I went back through and wrote down which chapter each question tested...and for me, the top three chapters/sections were as follows:
1) Creating/managing variables
2) SAS functions
3) Creating list reports
Once you've completed the Base SAS Certification practice test, be sure to go back through the questions you missed and review these areas. Chances are you'll be seeing questions similar to these on the exam day.
I hope this has been helpful for you all. Good luck with your studying, and if you have any questions or comments, feel free to leave a comment below!
-SAS Cert
To elaborate on my 2nd point in the before blog post, it's very important to buy the Base SAS Certification practice test. This practice test will give you a great benchmark of what your strong and weak areas are and how your should structure the rest of your studying prior to exam day.
You can purchase the practice test from the SAS Institute for $55 at the link below:
https://support.sas.com/edu/schedules.html?ctry=us&id=851
The practice exam is very similar to the actual Base SAS Certification for SAS 9 exam, but there are a few key differences that you should be aware of:
Number of Questions:
The practice exam has 50 questions, while the actual Base SAS Certification exam has 64 questions. Because the practice exam has fewer questions, the SAS Institute recommends that you use 85 minutes to take the practice exam (vs. 110 minutes on the actual exam).
Exam Format:
The practice exam is delivered on one continuous HTML screen. In contrast, the actual Base SAS Certification exam displays only one question on the screen at a time. You are also able to flag questions on the actual exam and return to them later...but you can't do this on the practice exam.
Keeping Time:
There is a timer displayed on the actual Base SAS Certification exam, but this isn't available on the practice exam.
In addition, the SAS Institute claims that the percentage of question topics on the practice exam match the question weights on the actual Base SAS Certification exam. When I finished taking the practice exam, I went back through and wrote down which chapter each question tested...and for me, the top three chapters/sections were as follows:
1) Creating/managing variables
2) SAS functions
3) Creating list reports
Once you've completed the Base SAS Certification practice test, be sure to go back through the questions you missed and review these areas. Chances are you'll be seeing questions similar to these on the exam day.
I hope this has been helpful for you all. Good luck with your studying, and if you have any questions or comments, feel free to leave a comment below!
-SAS Cert
Wednesday, April 17, 2013
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
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
Saturday, April 13, 2013
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
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
Tuesday, April 9, 2013
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
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
Friday, April 5, 2013
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
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
Tuesday, April 2, 2013
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
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
Saturday, March 30, 2013
Becoming Base SAS Certified Tip #1 - Repetition is Key
Hi everyone,
I'm working on a series of posts that are based on a previous blog post of mine below.
http://sascert3.blogspot.com/2013/03/how-to-become-base-sas-certified.html
My goal in this series is to expand on 5 main points that I believe are absolutely critical to passing the Base SAS Certification Exam for SAS 9. The first tip is that repetition is critical to learn and retain all the information on the Base SAS exam.
Tip #1 - Repetition is the Key
I'm sure by now you already know that the amount of information covered on the Base SAS exam is huge. The SAS Certification Prep Guide book has a total of 21 chapters and 794 pages.
Unless you have a photographic memory (I certainly don't), you won't be able to read this book though once and retain all the information. Even if you do have an awesome memory, the Base SAS exam asks some really tricky questions, and they make sure that you paid close attention to even the smallest details buried in the prep guide to get the 70% needed to pass.
Action Items:
To make sure you're able to learn and retain the information, I recommend buying and reading this prep guide through at least 2 times and completing the following action items:
The first time, read through the information in each chapter and complete the 10 questions at the end of these chapters. Don't feel like you have to get caught on every small detail at this point because you'll be reviewing and fine-tuning later on.
Next, check your answers with the key in the back of the book and review questions and areas that you missed or were unsure of. This will help you identify your weak spots and hopefully correct them early on in your studying.
The second time, re-read each chapter and create a cheat sheet of important topics and sample code for each of the 21 chapters. I included definitions, important functions, and any tips that the prep guide specifically called out. As you read through the material this time around, pay close attention to smaller details that you could picture being on the exam (Example: the length of resulting strings when using the SCAN function). Include this information in your cheat sheet so you can review it closer to exam time.
Summary:
This level of repetition will definitely get you ready for the Base SAS Certification for SAS 9 exam, and you'll walk into the testing center confident that you've read and reviewed every topic they could possibly throw at you.
Let me know if this was helpful to you by leaving a comment below. For those of you who have already passed the exam did you do anything differently while studying? I'd be curious to hear other effective studying methods.
Good luck studying!
SAS Cert
I'm working on a series of posts that are based on a previous blog post of mine below.
http://sascert3.blogspot.com/2013/03/how-to-become-base-sas-certified.html
My goal in this series is to expand on 5 main points that I believe are absolutely critical to passing the Base SAS Certification Exam for SAS 9. The first tip is that repetition is critical to learn and retain all the information on the Base SAS exam.
Tip #1 - Repetition is the Key
I'm sure by now you already know that the amount of information covered on the Base SAS exam is huge. The SAS Certification Prep Guide book has a total of 21 chapters and 794 pages.
Unless you have a photographic memory (I certainly don't), you won't be able to read this book though once and retain all the information. Even if you do have an awesome memory, the Base SAS exam asks some really tricky questions, and they make sure that you paid close attention to even the smallest details buried in the prep guide to get the 70% needed to pass.
Action Items:
To make sure you're able to learn and retain the information, I recommend buying and reading this prep guide through at least 2 times and completing the following action items:
The first time, read through the information in each chapter and complete the 10 questions at the end of these chapters. Don't feel like you have to get caught on every small detail at this point because you'll be reviewing and fine-tuning later on.
Next, check your answers with the key in the back of the book and review questions and areas that you missed or were unsure of. This will help you identify your weak spots and hopefully correct them early on in your studying.
The second time, re-read each chapter and create a cheat sheet of important topics and sample code for each of the 21 chapters. I included definitions, important functions, and any tips that the prep guide specifically called out. As you read through the material this time around, pay close attention to smaller details that you could picture being on the exam (Example: the length of resulting strings when using the SCAN function). Include this information in your cheat sheet so you can review it closer to exam time.
Summary:
This level of repetition will definitely get you ready for the Base SAS Certification for SAS 9 exam, and you'll walk into the testing center confident that you've read and reviewed every topic they could possibly throw at you.
Let me know if this was helpful to you by leaving a comment below. For those of you who have already passed the exam did you do anything differently while studying? I'd be curious to hear other effective studying methods.
Good luck studying!
SAS Cert
Wednesday, March 27, 2013
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
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
Monday, March 25, 2013
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
-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
Saturday, March 23, 2013
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';
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';
Thursday, March 21, 2013
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
-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
Tuesday, March 19, 2013
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
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
Sunday, March 17, 2013
SAS Certified Advanced Programmer Questions for You
Hi everyone,
I just purchased the study book for the SAS Certified Advanced Programmer for SAS 9 certification and am really excited to dive into the information when it comes to my apartment. My reasoning for diving back into the world of SAS certifications is that I learned so much studying for the base exam, and I wanted to keep learning and using these tips and tricks that you pick up along the way. Ultimately, I think that the material covered in the advanced certification will help me write slicker, more efficient code at my job which will make me look like a rock star at work.
I have a few questions for any of you who may have taken (and hopefully passed) this exam. I'm just trying to get a baseline of what studying for the exam will be like...
Is the advanced exam more difficult than the base exam?
Did you study longer for the advanced exam compared with the base exam?
Did you find the information more interesting?
Was it worth it to take the advanced certificate in the first place? Is the base certificate sufficient?
Thanks a lot for your help, and I'll be sure to let you all know how my studying is coming along.
SAS Cert
I just purchased the study book for the SAS Certified Advanced Programmer for SAS 9 certification and am really excited to dive into the information when it comes to my apartment. My reasoning for diving back into the world of SAS certifications is that I learned so much studying for the base exam, and I wanted to keep learning and using these tips and tricks that you pick up along the way. Ultimately, I think that the material covered in the advanced certification will help me write slicker, more efficient code at my job which will make me look like a rock star at work.
I have a few questions for any of you who may have taken (and hopefully passed) this exam. I'm just trying to get a baseline of what studying for the exam will be like...
Is the advanced exam more difficult than the base exam?
Did you study longer for the advanced exam compared with the base exam?
Did you find the information more interesting?
Was it worth it to take the advanced certificate in the first place? Is the base certificate sufficient?
Thanks a lot for your help, and I'll be sure to let you all know how my studying is coming along.
SAS Cert
Thursday, March 14, 2013
How to Become Base SAS Certified
Studying and passing the Base SAS Certification can seem extremely daunting at the beginning. There's a ton of information to memorize, the preparation materials are expensive, and it costs $180 to take (and possibly retake) the exam.
I managed to pass the Base SAS Certification after 3 months of studying, and I'll let you in on a few tips that helped me crack the test on my first try.
1) Repetition is the key
The SAS Certification Prep Guide for the Base exam is a total of 794 pages (21 chapters of information), and I managed to read this book two times completely through. The first time, I read the book straight through to get a gauge on what I really needed to focus on. The second time, I read the material but zeroed in on the difficult parts and tricky details that might be on the Base SAS Certification exam.
For more detailed examples of how to effectively read and study for the Base SAS exam, feel free to check out my latest blog post that carefully lays out how you should prepare. Hope it helps!
http://sascert3.blogspot.com/2013/03/becoming-base-sas-certified-tip-1.html
2) Buy the SAS practice test
SAS offers a practice test that is 50 questions as opposed to the 70 questions on the real test. This test is a great barometer of where you are in your studying and what you should focus on. I took this test about halfway through my studying (once I had read the book completely through) and looked up each problem that I missed. Later on, I re-took the test (even though I remembered the answers), which gave me a better sense of the types of problems and tricks that would be on the certification exam.
The link for the practice exam is below:
https://support.sas.com/edu/schedules.html?ctry=us&id=851
3) Create your own cliffnotes
I studied with the SAS Certification Prep Guide, Base Programming for SAS 9, Third Edition book, which has a total of 21 chapters. For each chapter, I made my own cliffnotes summarizing the key points. These are a great reference to have the closer you get to exam day.
***Leave me a message if you'd like me to scan and email you some of my notes. Having these could save you a lot of precious study time...
4) Make a schedule and stick to it
The Base SAS Certification tests a ton of information and a lot of the questions on the exam cover really small details that are buried in the book. The only way to get through everything is to lay out a schedule before you start studying and make sure that you stick to it. This way you won't run out of time a week before the exam and have to scramble to get through all the information.
5) Focus on learning, not memorizing
Remember...even though it's nice to have an extra certification listed on your resume, the skills you learn while studying for the Base SAS exam will help you all throughout your career. You may be able to memorize your way to the certification, but ultimately this won't help you if you can't remember any of the information the next day.
I hope this was helpful to everyone. For those of you who have passed any of the SAS certifications, did you find these rules to be true? Let me know in a comment below or feel free to post any other questions or comments that you have.
Take care,
SAS Cert
I managed to pass the Base SAS Certification after 3 months of studying, and I'll let you in on a few tips that helped me crack the test on my first try.
1) Repetition is the key
The SAS Certification Prep Guide for the Base exam is a total of 794 pages (21 chapters of information), and I managed to read this book two times completely through. The first time, I read the book straight through to get a gauge on what I really needed to focus on. The second time, I read the material but zeroed in on the difficult parts and tricky details that might be on the Base SAS Certification exam.
For more detailed examples of how to effectively read and study for the Base SAS exam, feel free to check out my latest blog post that carefully lays out how you should prepare. Hope it helps!
http://sascert3.blogspot.com/2013/03/becoming-base-sas-certified-tip-1.html
2) Buy the SAS practice test
SAS offers a practice test that is 50 questions as opposed to the 70 questions on the real test. This test is a great barometer of where you are in your studying and what you should focus on. I took this test about halfway through my studying (once I had read the book completely through) and looked up each problem that I missed. Later on, I re-took the test (even though I remembered the answers), which gave me a better sense of the types of problems and tricks that would be on the certification exam.
The link for the practice exam is below:
https://support.sas.com/edu/schedules.html?ctry=us&id=851
3) Create your own cliffnotes
I studied with the SAS Certification Prep Guide, Base Programming for SAS 9, Third Edition book, which has a total of 21 chapters. For each chapter, I made my own cliffnotes summarizing the key points. These are a great reference to have the closer you get to exam day.
***Leave me a message if you'd like me to scan and email you some of my notes. Having these could save you a lot of precious study time...
4) Make a schedule and stick to it
The Base SAS Certification tests a ton of information and a lot of the questions on the exam cover really small details that are buried in the book. The only way to get through everything is to lay out a schedule before you start studying and make sure that you stick to it. This way you won't run out of time a week before the exam and have to scramble to get through all the information.
5) Focus on learning, not memorizing
Remember...even though it's nice to have an extra certification listed on your resume, the skills you learn while studying for the Base SAS exam will help you all throughout your career. You may be able to memorize your way to the certification, but ultimately this won't help you if you can't remember any of the information the next day.
I hope this was helpful to everyone. For those of you who have passed any of the SAS certifications, did you find these rules to be true? Let me know in a comment below or feel free to post any other questions or comments that you have.
Take care,
SAS Cert
Tuesday, March 12, 2013
Number of SAS Certified Professionals Puzzle
Hi everyone,
I'm not sure if you all had heard this, but SAS recently received its 50,000th professional certification credential. According to the link below, the program launched 14 years ago and has averaged double digit growth since it began in 1998.
http://support.sas.com/certify/success.html
As a Certified Base Programmer for SAS 9, I can say for certain that I'm not just one in a million, I'm 1 in 50,000!
Let's turn this into a math problem...
***Use SAS to determine the average program growth rate assuming that SAS had a total of 1,000 professional certifications at the end of 1998. What would the average growth rate have to be each year to reach 50,000 professional certifications by the end of 2012?
Please post your code and answers below! I'm really interested to see the different ways people will use SAS to solve the problem. I'll post my solution in about a week...
Until next time,
SAS Cert
I'm not sure if you all had heard this, but SAS recently received its 50,000th professional certification credential. According to the link below, the program launched 14 years ago and has averaged double digit growth since it began in 1998.
http://support.sas.com/certify/success.html
As a Certified Base Programmer for SAS 9, I can say for certain that I'm not just one in a million, I'm 1 in 50,000!
Let's turn this into a math problem...
***Use SAS to determine the average program growth rate assuming that SAS had a total of 1,000 professional certifications at the end of 1998. What would the average growth rate have to be each year to reach 50,000 professional certifications by the end of 2012?
Please post your code and answers below! I'm really interested to see the different ways people will use SAS to solve the problem. I'll post my solution in about a week...
Until next time,
SAS Cert
Monday, March 11, 2013
SAS Cert Mission
The mission of my blog, SAS Cert, is to help readers become great at SAS and pass its certification exams.
I have been programming in SAS for a relatively short period of time, but I was completely blown away by its capabilities when I first started using it for work a few years back. I completed the SAS Certified Base Programmer for SAS 9 program, and the skills I attained through studying have certainly been helpful. In my day job as a data analyst, I can now pull, analyze, and report on data much faster than using SQL, Excel, or Access alone (or even combined). SAS is definitely a powerful tool if you know how to use it.
I plan on posting hints and tips about SAS, SAS sample questions and answers asked on the certification exams, and other SAS related topics. I hope you find it helpful.
Thanks,
SAS Cert
I have been programming in SAS for a relatively short period of time, but I was completely blown away by its capabilities when I first started using it for work a few years back. I completed the SAS Certified Base Programmer for SAS 9 program, and the skills I attained through studying have certainly been helpful. In my day job as a data analyst, I can now pull, analyze, and report on data much faster than using SQL, Excel, or Access alone (or even combined). SAS is definitely a powerful tool if you know how to use it.
I plan on posting hints and tips about SAS, SAS sample questions and answers asked on the certification exams, and other SAS related topics. I hope you find it helpful.
Thanks,
SAS Cert
Subscribe to:
Posts (Atom)