Author Archive

Everything Still Starts and Ends with Data in SAS Visual Analytics

July 30, 2013
By
Everything Still Starts and Ends with Data in SAS Visual Analytics

VA LASR Data Management

Author:

SAS Visual Analytics is changing the way data is analyzed and delivered in the SAS world.  The Visual Analytics LASR server brings a new method for handling large...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

Coding: Quick Tip for Exploiting and Identifying SAS Formats

July 15, 2013
By
Coding: Quick Tip for Exploiting and Identifying SAS Formats

SAS Formats Case Subcategory

Author:

SAS formats are very useful for translating values into other values.  You may want to format values for something more presentable, use the format to do lookups within an ETL process for...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

Describe Your Table in SAS to Write the SQL Code

May 22, 2013
By
Describe Your Table in SAS to Write the SQL Code

SQL Describe Code

Ever had the need to write SQL create statements for existing tables but felt too lazy to write it by hand?  Ever wanted to reverse ...

The post Describe Your Table in SAS to Write the SQL...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

Coalesce Missing Data to Highlight the Unknown

May 14, 2013
By
Coalesce Missing Data to Highlight the Unknown

Missing data can be a pain.  Having missing data and not knowing where it is can be even more of a pain.  Here is a ...

The post Coalesce Missing Data to Highlight the Unknown appeared first on Business Intelligence Notes...
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

Update Table Metadata Using Base SAS Code

December 19, 2012
By

Ever had the need to update table metadata by submitting SAS code?  If so, you can use PROC METALIB to do so.  This may be useful if you want to automate an ETL process, which loads tables and registers in metadata at the same time.  Update Existing...
Read more »

Tags: , ,
Posted in SAS | Comments Off

SAS Administration: Fetch Big Data Faster Across ODBC

November 1, 2012
By

On my current “big data” project, I’m connecting SAS to PostgreSQL using the ODBC access engine.  At first I was seeing pretty bad performance – specifically I wasn’t able to view the ~2.2 billion sample records I created...
Read more »

Posted in SAS | Comments Off

SAS Administration: Process Data Faster in RDBMS by Buffering the Data in Memory

October 3, 2012
By
SAS Administration: Process Data Faster in RDBMS by Buffering the Data in Memory

By default, accessing third party relational databases can be very slow if not configured properly.  I recently started using PostgreSQL 9.1, an open source database, to store high volumes of data for my SAS Global Forum 2013 paper.  At first it was taking forever to load up data because SAS was inserting 1 row...
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.