Tag: data step

Learn not one, not two, but four languages in SAS

I started young. Since I was 9 years old, I’ve always loved cooking delicious, tasty and healthy food, and feeding friends and family. My aunt still remembers the delicious chocolate soufflé that trembled and shook but would never collapse that I made for them when I was 18! Word spread. […]

The post Learn not one, not two, but four languages in SAS appeared first on SAS Learning Post.

Jedi SAS Tricks: Writing to Text Files from DS2

A reader posed a question in the comments to an earlier Jedi SAS Trick, asking how to write the results of a DS2 DATA _NULL_ program to a text file. It’s an interesting question, as DS2 currently has no text file handling statements or capabilities. Take, for example, this traditional […]

The post Jedi SAS Tricks: Writing to Text Files from DS2 appeared first on SAS Learning Post.

Jedi SAS Tricks: The DATA to DATA Step Macro

I was answering questions about SAS in a forum the other day, and it struck me how much easier it is to help folks if they can provide a snippet of data to go along with their program when asking others to help troubleshoot. This makes it easy to run […]

The post Jedi SAS Tricks: The DATA to DATA Step Macro appeared first on SAS Learning Post.

Jedi SAS Tricks – Maximum Warp with Hadoop

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 Jedi SAS Tricks – Maximum Warp with Hadoop appeared first on The SAS Training Post.

Turn your data set into a DATA step program

Sometimes I need to “disassemble” a SAS data set into a DATA step program. It’s kind of like creating a “freeze-dried” version of the data that you can carry around and use anywhere, re-hydrating it in the SAS session where you next need it. Some example uses for this: Build […]

Jedi SAS Tricks: FUNC(y) Formats

In the previous episode, we built our own custom SAS function – a masterful trick indeed. Gordon Keener, a developer here at SAS, responded exuberantly “You think that’s cool? – try THIS!” and proceeded to demonstrate prodigious powers with the SAS by …

Jedi SAS Tricks: These aren’t the droids… Episode 1

How the power of the Force makes ridding yourself of problematic characters so much easier! I recently was invited to become an alternate instructor for Ron Cody’s SAS Business Knowledge Series class, “SAS Functions by Example”, and had the privilege…

Bad words in SAS – PG rating

Picture this – a student grabs the Programming 1 textbook, scans it quickly seemingly searching for something specific, and shakes his head indicating an unsuccessful search. He plants himself smack dab in the front row, looks me squarely in the eye,…