|Date: ||Thu, 5 Oct 2006 07:46:25 -0700|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|Subject: ||Re: extracting data from sql server|
|Content-Type: ||text/plain; charset="iso-8859-1"|
i was finally able to hit the tables using SQL pass thru, but will test
your method as well..Thanks very much for your response..
> Dear Nevin,
> There are a number of possibele reasons. One is that the default schema for
> SQL server is called 'dbo'.
> If your tabels are not in dbo then you can add the schema=... option to your
> libname statement.
> Another possibility is that the names of your tables 'confuse' Sas. This can
> be mended with the preserve_tab_names=yes option on your libname statement.
> The libname options for ODBC are mentioned here:
> <email@example.com> wrote in message
> > Hello all,
> > I am attempting to extract data from a remote sql server database using
> > SAS. I am unfortunately running into some problems i hope you can help
> > me with..First a little background: i am using sas
> > 9.1 on an xp machine..I have an odbc connection set up with the remote
> > server which i tested by connecting with ACCESS (successfully)..when i
> > use the following code, the log states "odbc libref was successfully
> > assigned."
> > libname odbclib odbc dsn=hosp uid=xxx pwd=xxxx;
> > run;
> > however, when i use explorer in sas to view the newly created lib,
> > there are no datasets appearing..
> > Has anyone experienced this? and how can i fix it?
> > --thanks,
> > Nevin