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...
Read more »
Collecting ARM logs can be extremely useful when tuning OLAP cubes for faster response. The ARM log (which stands for Application Response Measurement) collects vital usage information for OLAP cubes using the SAS OLAP Server logging facility. SAS OLAP Cube studio can analyze these logs to assist with aggregation building to make OLAP cubes...
Read more »
SAS PROC SQL has a lot of neat ways you can extract and manipulate data. In my experience, SAS users typically write PROC SQL to query SAS datasets or relational tables in databases. You can also...
[[ This is a content summary only. Visit my webs...
Read more »
Back in September, I shared performance help for SAS 9 users who run on Windows 2008. At that time, I promised more insights from Margaret Crevar. Your next installment has arrived! For all the SAS customers running on AIX (5, 6, or 7), please note...
Read more »
As promised, this is a guest post by Steve Overton, who was one of the external reviewers on the Building Business Intelligence with SAS. Steve works as a SAS BI consultant in the Raleigh-Durham, NC area and is sharing some of his SAS OLAP Cube wizardry with us today! Building OLAP Cube Aggregations...
Read more »
Configuring and tuning an environment is part luck and part science. Luckily, a group of employees at SAS dedicate their time to helping you improve system performance. Margaret Crevar is one of those people. She just recently shared several papers w...
Read more »