Posts Tagged ‘ Metadata ’

New Game in Town: SAS Metadata Administration

March 14, 2013
By

You might also read that there were constant (although still not frequent) posts on SAS metadata querying and other administration tasks in SAS blogosphere since 2012 (when I started to play with it^). It is yet another evidence that more and more SAS programmers switched from SAS foundation to the so called SAS intelligent...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

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

March 11, 2013
By
Admins – Need to Restore One Metadata Object from a Backup?

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...
Read more »

Tags: , ,
Posted in SAS | Comments Off

Best of SAS: A Personal Nomination 2012

December 31, 2012
By
Best of SAS: A Personal Nomination 2012

There SAS applications/procedures/features were not necessarily available since 2012. This year I paid special attention to them when began to use SAS 9.3. The following notes are  totally my personal endorsement purely based my own experience as a user: XML File Reading: SAS XML Mapper SAS XML Mapper itself is not an elegant tool...
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: 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

Leverage metadata user synchronization macros for other uses

June 13, 2012
By

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 »

Tags: , ,
Posted in SAS | Comments Off

How did you find that metadata?

June 12, 2012
By

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 »

Tags: ,
Posted in SAS | Comments Off

SAS Enterprise Guide: Best Practice for Centralized User Storage

June 11, 2012
By
SAS Enterprise Guide: Best Practice for Centralized User Storage

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 »

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.