Date: Sun, 20 Jan 2008 10:08:32 -0800
Reply-To: dave crimkey <d_crimkey@YAHOO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: dave crimkey <d_crimkey@YAHOO.COM>
Subject: Import from SQL Server w/o SAS Access
Content-Type: text/plain; charset=iso-8859-1
I've been through the archives but am not real clear on this. Is there a way to import data into SASv9 from SQL Server 2000 if one does not have SAS ACCESS for SQL Server? Unfortunately, we only have SAS ACCESS for Oracle (and this works great) and SAS ACCESS for PC Files licensed and am told that we cannot get SAS ACCESS for SQL Server. I need to pull a large amount of data from a SQL Server and would rather not pull into txt or csv files. I read in the archives that SQL Server to XML to SAS works but needs some manipulation. What manipulation would be needed and how would I read this into SAS?
Thanks for any insight you can provide.
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.