Aside from Chris Hemedinger’s comment on SAS V9.3’s PROC SQL INTO enhancements, my Macro Arrays, Straight From a Data Set article last week also caught the attention of another friend and regular correspondent – LeRoy Bessler. LeRoy emailed m…
NOTE: SQL INTO, Revisited
In Macro Arrays Straight From a Data Set last week I wrote about using SQL’s INTO in order to create macro variables (and arrays of macro variables) from PROC SQL. I said that we had to use an arbitrarily large number to define the maximum size of the …
How to use MISSING(), NMISS() and the CMISS() functions
SAS provides several functions to test for
missing values but in this post we will focus on MISSING(), CMISS() and NMISS()
functions. The NMISS() function is reserved for numeric variables. The
MISSING() and CMISS() functions can be used with either ch…
How to search your SAS Enterprise Guide projects (2013 version)
Last year I published an example application for searching your SAS Enterprise Guide project files (EGP files). The example shows off some of the cool features of the automation API, and it’s a useful tool. As neat of an example as that was, it had some limitations. It worked only […]
How to send an email from SAS to members of a distribution list
In your organization, are you prevented from using the email alias of a distribution list (e.g. groupname@comp.domain.com), and would therefore like to extract the list recipients into a flat file to loop through/use the SAS Enterprise Miner functions,…
Getting Started in the Year of Statistics
~ Contributed by Maura Stokes, Sr Director, R&D, SAS ~ If you’ve been on the SAS campus lately, you would have noticed banners on the streets announcing 2013 as the International Year of Statistics. The major statistical societies designed …