Posts Tagged ‘ tips and tricks ’

Jedi SAS Tricks – Maximum Warp with Hadoop

July 20, 2015
By

I'm gearing up to teach the next "DS2 Programming Essentials with Hadoop" class, and thinking about Warp Speed DATA Steps with DS2 where I first demonstrated parallel processing using threads in base SAS. But how about DATA step processing at maximum warp? For that, we'll need a massively parallel processing

The post Read more »

Tags: , , , , , , ,
Posted in SAS | Comments Off on Jedi SAS Tricks – Maximum Warp with Hadoop

SAS Enterprise Guide: Suppress Output Data tab when programming

June 17, 2015
By

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

The post Read more »

Tags: , , , , ,
Posted in SAS | Comments Off on SAS Enterprise Guide: Suppress Output Data tab when programming

DATA STEP text file tricks

June 8, 2015
By

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

The post Read more »

Tags: , , ,
Posted in SAS | Comments Off on DATA STEP text file tricks

Weird PROC FREQ trick

June 4, 2015
By

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 Read more »

Tags: , , ,
Posted in SAS | Comments Off on Weird PROC FREQ trick

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

June 1, 2015
By

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 Read more »

Tags: , , ,
Posted in SAS | Comments Off on Looking for a SAS job? Join the 21-day SAS challenge

How analytics saved the break room coffee machine

May 28, 2015
By

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 Read more »

Tags: , , ,
Posted in SAS | Comments Off on How analytics saved the break room coffee machine

Dataset too big for PROC PRINT?

May 18, 2015
By

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 Read more »

Tags: , , , ,
Posted in SAS | Comments Off on Dataset too big for PROC PRINT?

Jedi SAS Tricks: Warp Speed DATA Steps with DS2

April 25, 2015
By

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 Read more »

Tags: , , ,
Posted in SAS | Comments Off on Jedi SAS Tricks: Warp Speed DATA Steps with DS2

Proc-x is looking for sponsors!

Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: tal.galili@gmail.com

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.