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.
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 …
Author: Quentin McMullen
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 Quentin McMullen. Go to Business Intelligence Notes for SAS® BI Users to subscribe.
In 1986 the Beastie Boys released their classic debut album, License to Ill, and the last track posed a question: “What’s the time?” The Beasties answered with an anthem, “It’s time to get ill.” I think Peter Cr…
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 […]
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…
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…
Marty HultgrenMichelle BucheckerSAS Global Forum creates a big buzz in the SAS user community, so in order to find out what the fuss is about, I decided to chat with a couple of our instructors who would be going to Las Vegas. In addition to teach…