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…
Tag: SAS BI Administration
Web Report Studio: Update Resources to Fix Your Report
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…
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 at a time into the database table. After adding a simple option my data processing was off to the races! Buffering Options The SAS INSERTBUFF and READBUFF options will improve ODBC and OLE DB libraries dramatically. By default these are set to 1 and 250 rows respectively for ODBC connections. Other third party databases, such as Oracle, DB2, or MS SQL Server, will probably benefit as well but I have not been able to test. Setting these buffer sizes tells SAS how many rows to buffer in memory before processing. Using the LIBNAME Option These options can be added to the LIBNAME statement to set the buffering sizes for all processing done on tables within the library. Ideally if you have the SAS Metadata server running, your SAS Administrator should set these options through the Data Library manager in SAS Management Console. If you are […]
The post SAS Administration: Process Data Faster in RDBMS by Buffering the Data in Memory appeared first on Business Intelligence Notes for SAS® BI Users.