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 »
Six user import and synchronization macros are available in the SAS Foundation directory, these are documented as available in creating programs to retrieve information and compare authentication provider (such as LDAP) account information with what is...
Read more »
A common question really and one that I get after posting code like yesterday's All SAS Stored Process Locations Report. The neat trick is just to type METABROWSE in a BASE SAS command window. (There are two other commands: METACON and METAFIND. Has an...
Read more »
A nice feature of SAS Enterprise Guide is the “Files” folder. This provides direct access to the file system where the workspace server is running. You can take advantage of this by configuring a central location where users can store data, SAS code, CSV files, Excel files, or anything useful. If this is not...
Read more »
You may be aware by now, our new SAS BI book Building Business Intelligence with SAS:Content Development Examples launched last week on the SAS Press site. That’s right, SAS Press or Amazon will be delighted to bring a copy of this SAS BI book to your door. When Angela and I set out to write...
Read more »
Quick Tip to Use when Creating a Metadata Library Here’s a quick tip for SAS BI Administrators or anyone who has to create metadata library in the SAS Management Console. Often before I define the metadata library I am at the folder or the physical path of the library. Obviously, it’s critical that the path is...
Read more »
As we have observed majorly in large enterprises, particularly the Banking and Finance sectors, there is always a huge amount of data building up every day. Moreover, one cannot ignore the fact that every observation in the database is linked up or imp...
Read more »
When working in SAS Enterprise Guide, you can access data from the metadata libraries. When you make changes to the datasets in the meta library, such as adding or modifying columns, or even deleted datasets, the metadata library does not have the data...
Read more »