Tag: macros

What’s the most popular language in each US state?

I can recognize several languages when I hear people speaking them (mostly because I lived in the Alexander International Dorm at NC State University). Therefore when I found a map of the most common languages spoken in each US state, it caught my attention, and I decided to try creating my […]

The post What’s the most popular language in each US state? appeared first on SAS Learning Post.

The First Snow of the Season in Saskatoon

Last week I had the distinct pleasure of hosting the Saskatoon SAS user group (SUCCESS) with the assistance of a vibrant, strong and engaged Executive Committee. My colleague Carolyn Cunnison remarked that I seemed to be smiling constantly while I was …

Using an Autocall Macro Library in SAS BI

Macro Library

Author:

 a SAS programmer, I am dependent on my SAS autocall macro library.  It stores a bunch of utility macros that I use on a daily basis. When I started learning about stored processes and other BI tools, one of my first thoughts was “How can I access all of my …

Post Using an Autocall Macro Library in SAS BI appeared first on Business Intelligence Notes for SAS® BI Users. Written by . Go to Business Intelligence Notes for SAS® BI Users to subscribe.

SAS Code: Simple Macro to Benchmark Data Performance

When troubleshooting data performance problems, IO problems, or simple library connectivity, I use a simple snippet of code to push the data storage to the limits.  It is useful because it stresses the data storage component, whether it be a SAS dataset on local file storage or an external database like Oracle, and it provides useful performance metrics.  To make it even better, since this is a SAS Macro it can easily be called multiple times for different libraries by setting the 2 parameters in the %BENCHMARK() macro.   Data Benchmark Macro Code The following code will take the CLASS dataset from the SASHELP library and continually append a specified number of iterations.  Be sure to include the OPTIONS statement to get the vital statistics in the log. [crayon-502242bf5ab3d/]   Output This is the output produced when the FULLSTIMER option is set.  These statistics were produced on my laptop with a solid state drive. NOTE: DATA statement used (Total process time):    real time 15.08 seconds    user cpu time 13.55 seconds    system cpu time 1.45 seconds    memory 414561.92k    OS Memory 439844.00k    Timestamp 08/01/2012 11:00:11 PM How fast can you run this code?  Remember to set […]

Jedi SAS Tricks: Building a Name Suffix variable list

If you’ve taken one of my SAS classes you may recall “Mark’s 3 rules of programming”, the first of which is “Lazy programmers are GOOD programmers.”  One of the things I love about best about SAS programming is the plethora of functions an…

Making SAS Interactive (Part 2): Using %window and %display

Its the world of GUI. And you are left nowhere if you don’t provide the users, the luxury (or rather fulfill the basic needs) of giving a Graphical User Interface. This holds good even for SAS. SAS came up with the tool called SAS/AF and SAS EG which p…