In my previous post, Jedi SAS Tricks - Make This a Button in Base SAS I demonstrated running a SAS program from a tool bar button in the SAS Windowing environment. The program we execute is the macro from a previous post, Jedi SAS Tricks: The DATA to DATA Step
Teaching SAS coding is fun. The best part of teaching is hearing success stories from candidates who earn a SAS certification after taking SAS training. Suiru Jiang is an MBA candidate who successfully passed her SAS certification exam. She took my five-day SAS programming fast track course at Goodman School
The journey continues as we hear from the instructors for each of the courses being offered on Thursday and Friday, April 21 and 22 after SAS Global Forum. Next up is Mark Jordan who developed and will teach the Introduction to DS2 and Hadoop course. Why should people get excited
The journey continues as we hear from instructors for each of the courses being offered on Thursday and Friday, April 21 and 22 after SAS Global Forum. Our next stop is with instructor David Ghan who is teaching the Using SAS® Programs to Execute Pig and HiveQL in Hadoop and
We continue to ready ourselves for this year’s SAS Global Forum coming up next month. On Monday, April 18, there will be two SAS Certification testing events. Then after the conference wraps up, SAS training instructors will be offering unique, hands-on training that you won’t find anywhere else. In this
Many of us here at SAS are hustling to prepare for SAS Global Forum set to begin April 18 in Las Vegas. This year’s agenda is shaping up to be a “can’t-miss” event. Monday, before SAS Global Forum begins, there are two SAS Certification testing events. Then after the conference
When I am discussing my new Explaining Analytics course with analytic professionals, I frequently hear, “I have a co-worker that needs the class.” That comment is much more frequent than – “Hey I need that class.” The truth of the matter is we all need to continue to improve –
You know when you visit Las Vegas you’ll have an experience you can only find in this one of a kind city. Where else can you gamble around the clock, get married in a drive-through, or see the Eiffel Tower without visiting Paris? So in the spirit of Vegas, SAS
Do any of your New Year’s resolutions include the goal to become a more productive SAS user? Whether you’re building models or reports using SAS or you’re using SAS to effectively manage your data, you likely have a goal to be as productive as possible with your SAS usage in
A number of years ago I was driving home to Alabama for the holidays. Typical of the season the driving was not easy. It was getting dark early and the traffic was fairly heavy. I had the radio on to pass the time. A talk show was on and the
Last Christmas I decided to knit a scarf while at a concert in the Bahamas. A little boy and his sister sitting in front of me watched me very intently. Their eyes grew bigger and bigger as the scarf grew longer and longer. Finally the little boy couldn’t take it
Ok, so the title is a little provocative, but some people are dubious that data science training is even possible, because they believe data science entails skills one can learn only on the job and not in a classroom. I am not in that camp, although I do believe that data
While holed up inside, like many others on the East Coast of the United States, suffering from record-breaking rainfall and watching the path of Hurricane Joaquin, I found a perfect metaphor for handling a problem in explaining analytics. Many executives bemoan the fact that it seems to take forever for
In October I will be at the Analytics 2015 conference in Las Vegas. I’ve never been to Las Vegas before. People tell me that if you are better than average in forecasting where a small ball will end up after it’s been spinning for a while in a dish with
Do you want to know what will happen in the future? To gain true predictive insight, skip the tea leaves and look toward your data. SAS instructor Jeff Thompson is a high-energy data mining expert who will be demonstrating how to gain predictive insight from your data in his new
Among the tightly held cards, piles of chips and bright lights, there have been stories that have unfolded in Las Vegas that have been forever preserved in time, never seeing the light of day. But what if what happened in Vegas…could be shared with excitement with your friends and family?
Suppose you wish to select a random sample from a large SAS dataset. No problem. The PROC SURVEYSELECT step below randomly selects a 2 percent sample: proc surveyselect data=large out=sample method=srs /* simple random sample */ n=1000000; /* sample size */ run; Do you have a SAS/STAT license? If not,
The digital disruption phenomenon is redrawing the market map. New players, products and services are gaining competitive advantage, while traditional business and revenue models are being questioned. Gartner believes that by 2020, thanks to the Internet of Things, information will be used to reinvent, digitalize or eliminate 80% of business
The 2015 United States Tennis Open tournament is now underway, and like most tennis fans, I’ve got my eyes on women’s tennis great Serena Williams, as she attempts to make history by winning the tournament and achieving a calendar Grand Slam. What are her chances of reaching the milestone? Most
This post is the third and final in a series that illustrates three different solutions to "flattening" hierarchical data. Don't forget to catch up with Part 1 and Part 2. Solution 2, from my previous post, created one observation per header record, with detail data in a wide format, like
I was recently asked why I would recommend my new class, Explaining Analytics to Decision Makers: Insights to Action. The answer goes back to some great advice, a lunch of eggplant parmesan and in another more twisted way, to what was ironically affectionately known as the “bomb plant.” Early in
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
A family and its members represent a simple hierarchy. For example, the Jones family has four members: A text file might represent this hierarchy with family records followed by family members' records, like this: The PROC FORMAT step below defines the codes in Column 1: proc format; value $type
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
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
I’m not a big gambler, but there is something I would put my money on – analytics. Analytics is helping companies turn information into value. And yes, I mean money. If you want to learn about the latest analytics trends and get in on some of that “value” – attend
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
If you have not yet discovered the new Ask the Expert series on the SAS Training site, you are missing out on a treasure. Visit the site right now and review all of the available topics, from "Newbie" to Analytics to Visualization to good ol' SAS programming. Go on; I'll
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;
If you have your SAS Certified Platform Administrator Credential, then it’s clear that you’ve studied a lot to achieve it. But suddenly the Hadoop era shows up and what you find are big gaps in your skills inventory. SAS administrators must be familiar with all the data SAS platform can
