Date:         Wed, 16 Jul 2008 15:20:49 -0400
Reply-To:     Phil Rack <PhilRack@MINEQUEST.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Phil Rack <PhilRack@MINEQUEST.COM>
Subject:      Re: Reading MS SQL Server files
Comments: To: Mary <mlhoward@avalon.net>
In-Reply-To:  <02d401c8e776$498ccaa0$832fa8c0@HP82083701405>
Content-Type: text/plain; charset="us-ascii"

http://www.microsoft.com/sql/editions/express/default.mspx
 On the right hand side, click "Download SQL Server Express"

Studio Express is a different product that you will need to download as well
if you want to make life easy for yourself.

R can read from ODBC connections of their is an ODBC driver. Google for
RODBC and SQL Server.

Phil


Philip Rack
MineQuest, LLC
SAS & WPS Consulting and Software Development
Tel: (614) 457-3714
Web: www.MineQuest.com
Blog: www.MineQuest.com/WordPress


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Mary
Sent: 07/16/2008 3:01 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Reading MS SQL Server files

Does someone know the link to get at MS SQL Server Express?   Friar mentions
Management Studio Express as needed as well; is this a different product?
Since SAS can't read Office 2007 files anyway, I'd like to try loading Excel
files into SQL Server Express and then having SAS access them from there.
Also, does anyone know if R can also read files stored in MS SQL Server
Express?

-Mary
  ----- Original Message -----
  From: Friar Broccoli
  To: SAS-L@LISTSERV.UGA.EDU
  Sent: Thursday, May 29, 2008 7:30 AM
  Subject: Re: Reading MS SQL Server files


  On May 28, 3:33 pm, HERMA...@WESTAT.COM (Sigurd Hermansen) wrote:
  > Microsoft now offers SQL Server Express as an option for limited access
  > to *.mdf archives of MS SQL Server databases. Whether free use licensing
  > includes your proposed use, I can't say. Even so I'd explore that route
  > before ODBC unless you are willing to license SAS/Access.
  > S

  Good News, and Am_I_Ever_Dumb.

  First, I installed SQL Server Management Studio Express
  and that added an ODBC driver for SQL Server (although
  that application does not allow data to be exported, as far
  as I can tell)

  I also ran this code
  http://www.sascommunity.org/wiki/Listing_Products_Installed

  and discovered that I have SAS Access installed.
  So if some kind soul could give me a hint about what I need
  to do to read MS SQL Server" (*.mdf/*.ldf) files directly
  with SAS, that would be much appreciated.

  Failing that, just a reconfirmation that I definitely can read
  those files directly from SAS (with Access) should get me started.



  >
  >
  >
  > -----Original Message-----
  > From: owner-sa...@listserv.uga.edu [mailto:owner-sa...@listserv.uga.edu]
  >
  > On Behalf Of Friar Broccoli
  > Sent: Wednesday, May 28, 2008 2:36 PM
  > To: sa...@uga.edu
  > Subject: Reading MS SQL Server files
  >
  > In my work I am more and more frequently receiving data in
  > "MS SQL Server" files which usually have the extension *.mdf.
  >
  > At present I take a (fairly long) walk and visit a person in my building
  > who has "MS SQL Server" installed on his machine He then converts the
  > files to Access (*.mdb) file format, which I know how to read directly
  > with SAS.
  >
  > So my questions are:
  >
  > 1- Is there some way of reading MS SQL tables directly with
  > sas without having "MS SQL Server" installed?
  >
  > 2- I understand that one can read *.mdf files from SAS
  > with an ODBC driver for SQL Server.  Is it possible to
  > obtain such a driver at a small cost or for free?
  >
  > Thanks;- Hide quoted text -
  >
  > - Show quoted text -