Posts Tagged ‘ tips and tricks ’

What’s wrong with this SAS program?

September 3, 2015
By

I think everyone can agree that being able to debug programs is an important skill for SAS programmers. That’s why Susan Slaughter and I devoted a whole chapter to it in The Little SAS® Book. I don’t know about you, but I think figuring out what’s wrong with my program

The post Read more »

Tags: , , , ,
Posted in SAS | Comments Off on What’s wrong with this SAS program?

Reading Hierarchical Data – Part 3

August 31, 2015
By

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

The post Read more »

Tags: , ,
Posted in SAS | Comments Off on Reading Hierarchical Data – Part 3

Reading hierarchical data – Part 2

August 27, 2015
By

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

The post Read more »

Tags: , , ,
Posted in SAS | Comments Off on Reading hierarchical data – Part 2

Reading hierarchical data – Part 1

August 25, 2015
By

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

The post Read more »

Tags: , ,
Posted in SAS | Comments Off on Reading hierarchical data – Part 1

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

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.