Hello SAS community,
I just completed my e-learning of SAS Programming 1: Essentials course this afternoon after studying over the past 3-4 weeks. I know I learned a lot and I'm most definitely interested in pursuing my education further in SAS. However I'm interested in any tips on how I can practice what I've learned so far? As I continue to teach myself more techniques and study for the Base Exam.
And I have copies of the SAS Programming books 1-3, Enterprise Guide 1 and the Little Book of SAS.
Also, I'm a business process improvement analyst for an insurance company, have flexibility with my manager to play with many reports and see how I can improve their functionality in using SAS 9.3. Are the essentials I learned a good base of manipulating excel documents (mostly spreadsheets, pivots, graphs and some vba macros)? What should I look for?
All ideas are appreciated, thanks!
Mathieu
I would see if you could get a copy of SAS 9.4
Things I would suggest learning:
For learning, I would suggest searching your topic of interest at LexJansen.com.
And last but not least, try your hand at answering questions on here. Don't look at the solutions first, but try and code it yourself. Then see what the solutions are. 1 question/20 minutes a day will have you up to speed in no time.
Hello,
One suggestion would be to get a copy of the SAS Certification Prep Guide BASE Programming for SAS 9. The book provides a great summary of many of the topics that you have already learned and is a good reference book. In addition there are quizzes at the end of each chapter and those quiz questions will allow for you to do some practice. You can find the book at: www.sas.com/store/books
This is just one idea.
Good luck to you.
I would see if you could get a copy of SAS 9.4
Things I would suggest learning:
For learning, I would suggest searching your topic of interest at LexJansen.com.
And last but not least, try your hand at answering questions on here. Don't look at the solutions first, but try and code it yourself. Then see what the solutions are. 1 question/20 minutes a day will have you up to speed in no time.
@analyticalgiant wrote:
Also, I'm a business process improvement analyst for an insurance company, have flexibility with my manager to play with many reports and see how I can improve their functionality in using SAS 9.3. Are the essentials I learned a good base of manipulating excel documents (mostly spreadsheets, pivots, graphs and some vba macros)? What should I look for?
I think your idea of replicating and modifying reports you already have is a good one. That way you have an idea of what the results should be though you may display them in a new fashion.
Depending on what and how you learned Excel functionality that may be an impediment to learning SAS. There are a number of things that some places do with Excel that new SAS users will attempt to replicate the Excel steps because they learned a mechanical process: "Highlight and push button" instead of "sum a group of values". The first doesn't lend itself to SAS but the second is another story.
One thing I might suggest would be to see how much you can do with Proc Report or Proc Tabulate (tabulate may be better if you nest groups in both rows and columns). Hint: If you are used to working with data that looks like:
Rowid January_value February_value March_value then 90% of the time you likely want to transpose the data to
Rowid Month Value where Month indicates January February etc.
This is a knowledge-sharing community for SAS Certified Professionals and anyone who wants to learn more about becoming SAS Certified. Ask questions and get answers fast. Share with others who are interested in certification and who are studying for certifications.To get the most from your community experience, use these getting-started resources:
Community Do's and Don'ts
How to add SAS syntax to your post
How to get fast, helpful answers
Ready to level-up your skills? Choose your own adventure.