Reading hierarchical data - Part 2

This post is the second in a series that illustrates three different solutions to "flattening" hierarchical data. Solution 1, from my previous post, created one observation per header record, summarizing the detail data with a COUNT variable, like this: Summary Approach: One observation per header record   Obs Family Count [...]

Post a Comment

Flexibility of SAS Enterprise Miner

Do you use an array of tools to perform predictive analytics on your data? Is your current tool not flexible enough to accommodate some of your requirements? SAS Enterprise Miner may be your solution. With growing number of data mining applications, having a tool which can do variety of analysis [...]

Post a Comment

Getting SAS certified one credential at a time

Krystian Matusz is what I’d call a super SAS user. He currently holds seven out of the nine credentials SAS offers. SAS Certified Advanced Programmer for SAS 9 SAS Certified Base Programmer for SAS 9 SAS Certified BI Content Developer for SAS 9 SAS Certified Clinical Trials Programmer Using SAS [...]

Post a Comment

Saint Peter’s University introduces Master’s degree in data science and business analytics

In December, Saint Peter’s University grants Master’s degrees to its inaugural class of data scientists.  36 students are enrolled in this program, and eight are set to graduate.   As reported this year by Bloomberg, career opportunities for analytics talent are excellent. Saint Peter’s is the latest to collaborate with SAS to offer such a program. [...]

Post a Comment

2 days. 2 exams. 2 SAS certifications.

In just one weekend Shang-Hua Wu went from a SAS user to a super SAS user by getting not just one, but two SAS certifications – SAS Certified Base Programmer and SAS Certified Advanced Programmer. Wu wanted to earn his certifications to position himself for new career opportunities in the [...]

Post a Comment

SAS Enterprise Guide: Suppress Output Data tab when programming

Have you ever waited a bit for SAS Enterprise Guide to display the Output Data tab when submitting a SAS program that generates multiple output tables?  Or, perhaps your program only generates one big output table but it takes a little while for it to surface on the Output Data [...]

Post a Comment

SAS Certification sets up Indiana University grads for success

A year ago, Love Bisht and Hardi Gokani were working toward their master’s degrees in information systems at Indiana University’s Kelley School of Business when SAS piqued their interest. Today, they’re newly minted graduates with a powerful extra credential – SAS Certification. Love and Hardi, both India natives, encountered SAS [...]

Post a Comment

DATA STEP text file tricks

When reading a text file (common extensions: TXT, DAT; or, for the adventurous: HTML) with the DATA STEP, you should always view several lines from the text file, and compare to the record layout, before completing the INPUT statement.  There are many ways to view a text file.  I use [...]

Post a Comment

Weird PROC FREQ trick

Default PROC FREQ output looks like this: Suppose you don't want the two cumulative statistic columns above.  No problem.  Those can be suppressed with the NOCUM option on the TABLE statement, like this: proc freq data=sashelp.shoes; table product / nocum; run; tags: learn sas, sas training, tips and tricks

Post a Comment

Looking for a SAS job? Join the 21-day SAS challenge

I recently taught a SAS training course where the students were very engaged. They had so many questions, I could have spent the next month writing helpful blog posts that came from that one class. However, I picked this one question that the class begged for me to share. The [...]

Post a Comment