Do you use SAS for analytics and Microsoft Excel for graphs? Why not use SAS for your graphs too?!? Then you could completely automate the entire process in one SAS program, with no manual steps! A lot of people use Excel to create their graphs be…
The hottest trends in analytics
Leading up to the Analytics 2012 Conference, we’re going to explore the latest trends in analytics. For this, we reached out to several of our speakers and sponsors to get their take on what’s catching fire. The one we found on almost everyone’s …
Testing recommendations for SAS BI Dashboard & SAS Web Report Studio
With limited time and budget, you can still thoroughly test SAS reports built in SAS BI Dashboard and SAS Web Report Studio by considering how all the tools were used to build the end report. An understanding of the functionality within each part of th…
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 […]
Analytics training at a huge discount
You may know that every year at the Analytics Conference, we offer pre-conference workshops and post-conference training courses. But, did you know that these offerings are significantly discounted? Come to Las Vegas for the Analytics Conference and ma…
Metacoda’s Metadata Explorer Plug-in
My work at Metacoda involves lots of metadata, as does my work as in SAS® platform administration. I spend a lot of time looking inside SAS metadata repositories, searching for objects, looking at their attributes, following their associations to …