Date:         Wed, 8 Jul 1998 12:15:46 -0700
Reply-To:     jjones@vnusinfo.com
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Jason Jones <jjones@VNUSINFO.COM>
Comments: To: "Vyverman, Koen" <FT64312@UK.FID-INTL.COM>
In-Reply-To:  <c=US%a=_%p=FIDELITY%l=LXKAN713NTS-980708130254Z-2068@ukkwd700nts.hld.uk.fid-intl.com>
Content-Type: text/plain; charset="iso-8859-1"

Koen,
        Here's some sample code I've used:
 
PROC SQL;
   CONNECT TO ODBC AS gerd (DSN="Access97GERD" UID=admin);
   CREATE TABLE work.baseline AS
   SELECT *
      FROM CONNECTION TO gerd
         (SELECT *
             FROM tblBaseline
             WHERE entrynum=3);
   DISCONNECT FROM gerd;
QUIT;
 
Hope it helps.
 
                                        Jason
 
Jason Jones
VNUS Information Services
213.924.3111
http://www.vnusinfo.com