Date:         Sat, 10 Mar 2001 09:46:09 GMT
Reply-To:     grueninger@ibgrueninger.de
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Andreas Grueninger <grueninger@IBGRUENINGER.DE>
Organization: Ingenieurbuero Grueninger
Subject:      Re: datastep or SQL views: is it possible to embed libname
              definition s? + SQL question*
Content-Type: text/plain; charset=ISO-8859-1

Personally I would not embed the libnames in the views.

If you have to create the views on several machines you have to
maintain several programs to create the views. This will be more and
more cumbersome if the numbers of views and  of machines will grow and
with a lot of changes in the definitions of the views.

I would create a macro which
1. checks on which system (machine and SAS system) it is actually
called
2.  calls another macro which defines the libnames dependent on
machine and SAS system
3.  calls a SAS file which defines the views and stores them
permanently.

If the user starts a session only 1. and 2. are used and the views are
present.
If the developper has to make changes he/she
1. checks the libnames for all machines
2. creates/changes the code
3. copies the new macros to the systems
4. start the macros and creates the views on all systems.

With this  approach you have just one file for all systems where you
have to make changes

You mentioned there is no common autoexec.sas.
But you need to define a libname to find the permanently stored views
on the remote machine.
In this case you can call the above mentioned macro. From the users
point of view it would be no difference.


tlk94092@GLAXOWELLCOME.COM (Kirkland, Tammie L) wrote:

>Wonderful! Just what I needed.
>Thanks,
>Tammie
>



* --------------------------------- +
! Ingenieurbuero Grueninger         !
! Andreas Grueninger                !
! Uhlbergstr. 15                    !
! 72631 Aichtal (Germany)           !
! email: grueninger@ibgrueninger.de !
+ --------------------------------- ;