Tag: in-database

Sorting data in SAS: can you skip it?

TL;DR The next time that you find yourself writing a PROC SORT step, verify that you’re working with the SAS Base engine and not a database. If your data is in a database, skip the SORT! The details: When to skip the PROC SORT step Many SAS procedures allow you […]

The post Sorting data in SAS: can you skip it? appeared first on The SAS Dummy.

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.

Just-in-time data prep in SAS Enterprise Guide

On this blog, I’ve delivered a few tips about using SAS formats to stratify your data values “in place” without having to actually change your data. The most recent example addressed date and datetime variables. My previous examples included simple SAS programs that you can run in SAS display manager […]