Tag: syntax

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…

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…

NOTE: Calling Stored Processes from SAS Code (PROC STP)

Stored Processes. Brilliant. An excellent (and easy) means of packaging your SAS code and making it available in parameter-driven form through Enterprise Guide, Microsoft Office applications (through the SAS Add-In for Microsoft Office), Information Ma…

NOTE: More on Date Increments (INTCK and INTNX)

It’s always encouraging to get feedback about my blog articles and/or see an article spark some conversation. Last week’s Date Increments (INTNX and INTCK) featured the INTNX function for incrementing (or decrementing) date, time, and datetime values b…

NOTE: What Am I Reading?

We all try to write data-driven code, or code that provides some degree of flexibility regarding its input data. We see these approaches as reducing maintenance and making the code more robust. There are a number of features in the SAS language that al…

NOTE: New Ways in Means

There aren’t many SAS programmers who haven’t used PROC MEANS (or its alter ego PROC SUMMARY) to aggregate (summarise) their data. PROC MEANS is a familiar tool for most SAS programmers, and the process of subsequently selecting specific values of _TYP…

NOTE: A Book That Grows? That’s Got To Be A New Concept!

Following my feature of Metacoda and their security plug-ins last week, I have to feature Phil Holland. As I said last week, I’m a keen supporter of the third-party market for SAS-related products. In addition to his two published books (Saving Time an…

NOTE: When WORK is not WORK (Update)

That’s what happens when you take a break! I’ve not posted in here for a couple of months; my first post after my break (NOTE: When WORK is not WORK) looks a little sloppy. Damn!

The information was technically correct, but I’ve had a couple of polite…