Posts Tagged ‘ SAS BI Administration ’

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

Web Report Studio: Update Resources to Fix Your Report

December 10, 2012
By

Is there a worse way to start your day than someone calling to tell you that your marvelous Web Report Studio report is not working? Yes, this means the world is being denied a viewing of your stunning visual design efforts about last quarter’s s...
Read more »

Tags: , , , ,
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.