| 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 |
|
| 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/
|