Posts Tagged ‘ performance ’

NOTE: DS2, Final Comments

February 20, 2013
By

In my previous posts, I've covered many aspects of DS2 (previous posts are listed at the bottom of this post). It's time to wrap up by offering a few more final details. Whilst DS2 provides a wide range of data types, not all types are supported by all...
Read more »

Tags: , , , ,
Posted in SAS | Comments Off

NOTE: DS2, Threaded Processing

February 18, 2013
By

In my recent posts on DS2 (DATA step evolved), I showed the basic syntax plus packages & methods, and I showed the use of SQL within a SET statement. In today's post, I'll show the biggest raison d'être for DS2 - the ability to run your code in th...
Read more »

Tags: , ,
Posted in SAS | Comments Off

NOTE: DS2, SQL Within a SET Statement

February 13, 2013
By

Earlier this week, I suggested taking a look at DS2 ("the DATA step evolved") as a learning opportunity for the New Year. I listed the advantages that DS2 offers over the traditional DATA step. One of those was the ability to use SQL within a SET state...
Read more »

Tags: , ,
Posted in SAS | Comments Off

NOTE: DS2, Learn Something New!

February 11, 2013
By

There's never a bad time to learn something new. How about DS2? In May of last year, upon returning home from SAS Global Forum, I wrote about DS2, a new alternative to DATA step. Generally available in V9.4, PROC DS2 is currently available in SAS...
Read more »

Tags: , ,
Posted in SAS | Comments Off

SAS Administration: Change the Options to Get More Performance

January 21, 2013
By

Every time I install SAS products or solutions I find myself using the same options in the SAS configuration file to set memory usage, CPU usage, and the SAS WORK library location.  Obviously each installation has...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

SAS Code: Simple Macro to Benchmark Data Performance

August 8, 2012
By
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...
Read more »

Tags: , , , ,
Posted in SAS | Comments Off

SAS OLAP Cubes: Automatically Collect ARM Performance Logs

June 18, 2012
By
SAS OLAP Cubes: Automatically Collect ARM Performance Logs

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 »

Tags: , ,
Posted in SAS | Comments Off

SAS OLAP Cubes: Using PROC SQL and MDX to Query OLAP Cubes

January 11, 2012
By

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 »

Tags: , , , , , ,
Posted in SAS | Comments Off

Proc-x is looking for sponsors!

Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: [email protected]

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.