Use utility #4 to discover your libname. Whenever I need a SAS libname for a
database, I use it to do the discovery. You can find it here:
I built this for a SAS client who needed to move data back and forth. After
you have the libname, you should be in good shape.
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Ben
Sent: Thursday, June 19, 2008 5:45 AM
Subject: SQL Enterprise connection question
Where I'm working we currently create several DTS packages for each of
studies in SQL Enterprise to create different csv files of the study
data. We have SAS/ACCESS licence and I am looking to use this to read
the SQL tables direct to SAS to create an instant data cut.
I've tried looking this up but it seems I need to use a libname
statement defined as 'sqlsvr'. My problem though is I don't know what
options I need or how to reference the databases from here. Can anyone
give me an overview on how to do this?
Many thanks in advance!