BI Tools

Tips and tricks for building information maps, OLAP cubes, reports, and dashboards

BI Admin

Learn your way around a SAS BI installation.

Visual Analytics

Learn your way around the SAS Visual Analytics tool

Coding & Data

Extract, transform, and load your data into the SAS BI toolset

Stored Processes

Create and design stored processes like a rock star

Home » Archive by Tags

Articles tagged with: Metadata Answers

Administration: Retrieving Passwords from the SAS Metadata

2014-01-13 – 8:11 AM
2014 01 13 admin find userid 03 thumb

When working with the SAS metadata, sometimes a developer needs to retrieve a user ID and password from the metadata. For instance a developer may need the encoded password to connect to the database using the SAS pass-through with relational databases like Oracle and TeraData.  [More discussion about the pass-through :  here with TeraData, here compared to Libname, and here in SAS 9.2 doc set.]
As …

What’s the difference between SAS Enterprise Guide and SAS DI Studio?

2013-11-16 – 9:57 PM
SAS DI Studio

A question SAS programmers/users sometimes ask me is “What’s the difference between SAS Enterprise Guide (EG) and SAS Data Integration Studio (DI)?” Both run SAS code and can generate tables and reports… my one-line response is “it’s about those SAS jobs being SAS metadata objects.”
It’s about the Metadata
What do I mean by this? Well, in EG you work with tables and SAS code (either with …

Admins – Need to Restore One Metadata Object from a Backup?

2013-03-11 – 10:48 AM
metadata_backup_01

When I think of corruption, it usually is more about government.  Certainly, I don’t picture myself slipping a C-Note to the metadata server for favors, such as giving me special access or maybe ensuing my jobs have priority (wink). Stig Eide, a SAS BI administrator, reminds me that corruption does occur in the metadata – but not exactly  what I was picturing.  When metadata corruption occurs, …

Update Table Metadata Using Base SAS Code

2012-12-19 – 5:55 AM
Summary Output from PROC Metalib

Ever had the need to update as table metadata by submitting SAS code?  If so, you can use the SAS BI METALIB procedure 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 Table in SAS BI Metadata
The following code connects to a SAS library already registered in metadata and …

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

2012-10-03 – 8:37 AM
SMC libname ODBC buffering

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.  In this example I am using an ODBC connection to connect to a database I defined in Postgres.  Native SAS/ACCESS engines to databases such as Oracle or …