PROC-X.com
An online (unofficial) SAS® journal – written by bloggers

Main menu

Skip to content
  • About
  • add your blog
  • Contact us
SAS

Integrating Enterprise Miner and SAS Metadata / Enterprise Guide created datasets

by Shane Gibson • June 2, 2011 • Comments Off on Integrating Enterprise Miner and SAS Metadata / Enterprise Guide created datasets

This post was kindly contributed by Blogging about all things SAS - go there to comment and to read the full post.

When you us SAS Enterprise Miner 6.2 you need to access data to perform the modeling tasks (DOH ;-)

When adding data sources to your EM project you can either add data from a SAS Table or from the Metadata Repository.

If you add it from a SAS Table, then SAS will display all the libnames defined in the autoexec.sas.

If you access the tables via metadata then SAS wil display the metadata libnames, which in an managed environment is our recomended option.

The trick is of course the datasets that are being accessed have probably been created by a modeler using Enterprise Guide.  And when the modeler creates them via EG they are not automatically registered in metadata.  So therefore they are not automatically available in Enterprise Miner.

Options I can think of:

  1. Make the modelers use DI Studio as it automatically registers the tables
  2. Give the modelers access to SAS Management Console and rights to register metadata
  3. Use the EG addin that lest users register metadata
  4. Create the libnames in the Autoexec, SAS will automatically display all tables that are present in that directory.

I gotta say im not loving any of those options!

Hit me if you can think of any I have missed.

====Update=====

Chris posted a comment to remind me that the ability to update SAS Metadata is now base functionality in SAS 9.2 / EG 4.3 (Tools->Update Library Metadata).  Worked a treat, problem solved!  (thanks Chris)

 

 

 

Share

This post was kindly contributed by Blogging about all things SAS - go there to comment and to read the full post.

Tags: registering Metadata SAS 9.2 SAS Enterprise Miner 6.2

Post navigation

← The Reviewer Is Always Right
SAS 9.3 to be released in July 2011 (maybe ;-) →

Popular Posts

  • SAS – Lowercase (lowcase) / Uppercase (upcase) / Proper Case (propcase)
  • How do I export from SAS to Excel files: Let me count the ways
  • How to Get Row Numbers in SAS Proc SQL (and DO NOT Use the Undocumented MONOTONIC Function)
  • How to convert the datetime character string to SAS datetime value? (ANYDTDTM and MDYAMPM formats)
  • Using SAS Enterprise Guide to run programs in batch
  • Clear the Results viewer in SAS 9.3

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.

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: tal.galili@gmail.com

Contributors

  • AFHood Group Blog » SAS
  • Avocet Solutions
  • BI Notes
  • Blogging about all things SAS
  • BusinessKen
  • Computing from Out in Left Field
  • Data Steps
  • Enterprise Software Doesn’t Have to Suck
  • Gregor Gorjanc (gg)
  • Heuristic Andrew
  • Jared Prins’ Blog – SAS
  • Ken's SAS tricks
  • Michael @ Scorpio
  • Musings From an Outlier: The SAS Users Blog
  • NOTE: Development With SAS
  • Numbermonger » SAS
  • Peer Revue
  • Peter Flom blog (Statistical Analysis Consulting)
  • platformadmin.com
  • ProcRun;
  • SAS – BioStatMatt
  • SAS – Confounded by Confounding
  • SAS – From a Logical Point of View
  • SAS & Statistics
  • SAS | r4stats.com
  • SAS and R
  • SAS Learning Post
  • SAS Live!
  • Sas on Melinda Higgins, Ph.D
  • SAS Programming for Data Mining
  • SAS support site – SAS Users
  • SAS Users
  • SAS-BI Business Layers
  • SASopedia
  • SASTechies
  • Software & Service
  • Statistical Analysis Consulting
  • StudySAS Blog
  • The SAS Dummy

Recent Posts

  • Automatic cloning of SAS metadata user groups and roles
  • What is SAS Viya?
  • Understanding the _TYPE_ variable in output data sets
  • New certification alert: SAS® Certified Specialist: Administration of SAS® Viya®
  • SAS training: 5 free sessions technologists love
  • Creating a Microsoft Excel report using SAS, Python and SQL!
  • Decode your SAS® macro code with the MFILE and MPRINT options
  • ESM and S9CA: Useful Tools for Migration from SAS 9 to SAS Viya
  • CAS-Action! Advanced Frequency Tables – Part 4
  • CAS-Action! Grouping Frequency Tables – Part 3
  • Using SAS to score a test
  • CAS-Action! Saving Frequency Tables – Part 2
  • CAS-Action! Simple Frequency Tables – Part 1
  • CAS-Action! Rename Columns in a CAS Table
  • Details, details: Updates to The Little SAS Book

Copyright © 2023 PROC-X.com. All Rights Reserved. The Magazine Basic Theme by bavotasan.com.