Further to my post on Executing a PROC from a DATA Step, Quentin commented and drew my attention to a highly informative SAS Global Forum paper on the same subject by Mike Rhoads. I’m grateful to Quentin; Mike’s paper offers a lot of insight and expe…
Tag: SAS
How to Jump into SAS Data Integration Studio
This is for for SAS programmers who might be reluctant to check out a GUI tool like SAS Data Integration Studio (DIS for short, which is graphic tool to implement ETL processes: extract, transform, load). DIS translates all users dragged nodes, transformations and process into SAS codes which are traditionally written by SAS programmers. I […]
How to Get Row Numbers in SAS Proc SQL (and DO NOT Use the Undocumented MONOTONIC Function)
SAS programmers are longing for row number function used in Proc SQL, like ROW_NUMBER() in Oracle SQL and it will act like data step system variable _N_. When you google this question, most likely you will get MONOTONIC() function, which might be one of the most famous undocumented features shipped by SAS. You can of […]
NOTE: Are You Game for Big Data Overload?
Earlier this week, SAS launched a new software product. It’s free! AND it runs on Android and Apple iOS devices!! What am I talking about?… the latest craze to hit analytics offices worldwide… Big Data Overload, the game.
This is a fun game in …
NOTE: The OPEN Function (reading data sets in macros)
In my previous post on this subject, I showed how to use the DATA step’s OPEN function to get information about data sets and make that information available within a DATA step or as a macro variable. In today’s post I will take it further and show how…
NOTE: Executing a PROC from a DATA Step
I stumbled across a most informative SAS Global Forum paper the other day, and I wanted to share it with you! In his Executing a PROC from a DATA Step paper, SAS’s Jason Secosky describes the RUN_MACRO and DOSUBL functions, both of which were new to me…
SAS Stored Process Code in Metadata
With SAS® 9.3 the SAS code for a Stored Process can be located in metadata rather than located the file system (as was required with earlier versions). I had often wondered whether this meant the SAS code was really in metadata or whether it appea…
NOTE: The OPEN Function (getting data set information in macros)
There are a number of ways of accessing the content of SAS data sets. DATA steps and PROCs are two obvious means. Another method is to use the DATA step’s OPEN function.
Let’s start with some basics. Here’s a DATA step that is able to establish whethe…