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…
Controlling access to custom tasks in SAS Enterprise Guide
I’ve bragged about how easy it is to install custom tasks for SAS Enterprise Guide. It’s simple: you copy the .NET assembly (usually a single DLL file) into one of the designated folders in your SAS Enterprise Guide installation, and your task just shows up in the menu. Since I […]
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…
Get Started with SAS Tagsets.ExcelXP
Hate it or not (Yes I do), SAS programmers can’t just get rid of Microsoft Office Excel in their life. Now my turn (with Tagsets.ExcelXP, I can at least get rid of DDE)… 0. SAS Templates window A visual way to browse all ODS templates is to use windows command “ODSTEMPLATES” to invoke a SAS […]