Date:         Fri, 24 Sep 2004 14:55:32 -0700
Reply-To:     Bob Lan <baoxian_lan@EXCITE.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Bob Lan <baoxian_lan@EXCITE.COM>
Organization: http://groups.google.com
Subject:      Re: Is it possible to specify a relative path in an SQL view?
Content-Type: text/plain; charset=ISO-8859-1

Hi there,

There is something called 'Embedded Libname Statement'. You use USING
clause to embed the libname statement. There could be better ways but
here is a simple example.

libname test 'c:\temp';

data test.classF;
   set sashelp.class;
   where sex='F';
run;

proc sql;
   create view test.class12 as
   select *
      from test.class
      where age lt 13
      using libname test 'c:\temp';
quit;


libname libchg 'c:\temp';
proc print data=libchg.class12;
run;