LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (November 2000, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Wed, 15 Nov 2000 11:36:43 -0800
Reply-To:   Meredith Clark <clarkmeredith@YAHOO.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Meredith Clark <clarkmeredith@YAHOO.COM>
Subject:   Re: registration of MDDB
Comments:   To: Rain Oks <Rain.Oks@RESTA.EE>
Content-Type:   text/plain; charset=us-ascii

Rain, I have some code here that I run in batch mode, although I had to run it in EIS for the first time. This is run on Windows NT for SAS 6.12. Hope this gives you an idea. Meredith

<this is a snipped portion of a 'batch' program I run to update a data base. The following pertains to updating the metabase> .... ****Remote session does not support Data Manager commands; endrsubmit; dm 'af catalog=eisappl.eisplace.compcol.scl'; ***makes computed columns; dm 'runeis appl=eisappl.eisplace.add_mddb.af';

***** registers the new metabase-wont register any new changes; ***** until you register it - new variables, etc.;

***** if this doesnt work, manually go into the Metabase, ***** delete the existing Metabase, then add it in again, ***** and you should see the new changes;

***** if, when you run this, you get the message that the ***** metabase is already registered, it wont get

***** updated;

rsubmit;

........ <end of 'batch' program>

(CLNTMDDB is the library which houses the metabase.) (This is the scl behind the af object)

*****eisappl.eisplace.addmddb.scl;

/*************************************************************

This code will add a new MDDB to existing SAS/EIS metabase. By default all cla ss and analysis variables, as well as displayable hierarchies will be register ed to the metabase.

Since the SAS/EIS environment has to be active to use SAS/EIS classes, you wil l have to execute this SCL code as an EIS application. You can do this by cre ating an AF object under the Build EIS 'Add' button under 'Utilities' and 'SAS /AF application' and pointing the SCL code contained below. You can then exec ute the EIS application by issuing the command:

RUNEIS APPL=LIBREF.APPDBASE.ADD_MDDB.AF

**************************************************************/

length msg $80;

INIT:

mbase_class=loadclass('sashelp.mb.metabase.class');

mbid=instance(mbase_class);

call send(mbid,'_register_mddb_',rc,msg,'CLNTMDDB.eisappl',

'clntmddb.qunt2');

put _all_;

call send(mbid,'_register_mddb_',rc,msg,'CLNTMDDB.eisappl',

'clntmddb.summ2');

put _all_;

call send(mbid,'_register_mddb_',rc,msg,'CLNTMDDB.eisappl',

'clntmddb.naqunt');

put _all_;

call send(mbid,'_TERM_');

return;

***************end of scl************************;

--- Rain Oks <Rain.Oks@RESTA.EE> wrote: > To someone with excellent knowledges about SAS!! :) > > Is it possible to registrate MDDB in repository > using SAS program, not using > SAS EIS interface? > And the first question - how? > > With never-ending thanks > Rain Oks

===== Meredith Clark Senior Programmer/ Applications Developer Harte-Hanks Data Services

__________________________________________________ Do You Yahoo!? Yahoo! Calendar - Get organized for the holidays! http://calendar.yahoo.com/


Back to: Top of message | Previous page | Main SAS-L page