Note to the user in using these that you need to setup an ODBC Data Source on your PC to SQL Server, then you would use that name in the code in your libname statement.

-Mary ----- Original Message ----- From: Friar Broccoli To: SAS-L@LISTSERV.UGA.EDU Sent: Friday, August 01, 2008 2:00 PM Subject: Re: SQL to SAS

On Aug 1, 1:17 pm, johnita_b...@HOTMAIL.COM (Johnita Byrd) wrote: > Hello All=2C > =20 > I have created a SQL database that I would like to put into SAS. The datab= > ase is large (45K+ patients) so I have little experience with importing dat= > a of this size into SAS. If anyone can give me some guidance on the best w= > ay to import the SQL data into SAS=2C it would be greatly appreciated. Tha= > nk you in advance for all of your help. > =20 > Johnita >

If you're using MS SQL Server, these artlcles may help:

http://groups.google.com/group/comp.soft-sys.sas/msg/89d987cf94aa9d2f http://groups.google.com/group/comp.soft-sys.sas/msg/41d8f48782a626c7