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; Now your output looks like this, but you lose […]
The post Weird PROC FREQ trick appeared first on The SAS Training Post.
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 […]
The post Looking for a SAS job? Join the 21-day SAS challenge appeared first on The SAS Training Post.
SAS software is used around the world in some of the most sophisticated ways, like ATM fraud detection and cancer research. But recently, I used it for a practical, and much needed, task — replacing our break room coffee machine. Now, this is no ordinary coffee machine. It also makes […]
The post How analytics saved the break room coffee machine appeared first on The SAS Training Post.
Dataset too big for PROC PRINT? One weird trick solves your problem! proc print data=bigdata (obs=10); run; The OBS= dataset option specifies the last observation to process from an input dataset. In the above example, regardless of dataset size, only the first 10 observations are printed; an easy way to […]
The post Dataset too big for PROC PRINT? appeared first on The SAS Training Post.
I remember the first time I was faced with the challenge of parallelizing a DATA step process. It was 2001 and SAS V8.1 was shiny and new. We were processing very large data sets, and the computations performed on each record were quite complex. The processing was crawling along on […]
The post Jedi SAS Tricks: Warp Speed DATA Steps with DS2 appeared first on The SAS Training Post.
The best graphs are both beautiful and informative – a smooth blend of art and analytics. But more often than not, the two collide rather than blending smoothly… Here is a link to a artistic infographic I recently saw posted by Vendavo on twitter. Their message (80% of your profit is generated […]
The post When art and analytics collide appeared first on The SAS Training Post.
In this tutorial video, you will learn how to read comma-separated-value (CSV) files with Base SAS using a DATA step. This enables you to create a SAS data set copy that transforms each field in the raw data file into a variable in the data set. Watch …
Michele Ensor recently posted a wonderful blog with a graph of the 2014 Winter Olympics medal count. I’m going to further refine that graph, making it an Olympic graph … on steroids! 🙂 Here is Michele’s graph: First, let’s give it a few simple cosmetic changes. I always like to have […]