SAS University Edition: Can I access data in an MS SQL Server database?

Reply
New Contributor
Posts: 2

SAS University Edition: Can I access data in an MS SQL Server database?

Hi,

I've just started kicking the wheels of the university edition. My notebook is running SAS UE in an Oracle Vitualbox hosted environment, and MS Sql-Server.

I'd like to access the database - is this possible with the University Edition?

I've found and tried some Library statements, but I get an error about a missing odbc library module on the Linux side.

Any help would be appreciated.

Chris.

Contributor
Posts: 32

Re: SAS University Edition: Can I access data in an MS SQL Server database?

Chris

I don't work in Linux but here are a couple of things that I found were important for gaining access to an Oracle database on our network. I needed whatever an ODBC driver installed which I later modified to specifications of the database. I had to have Oracle Client installed which is free. You can go to their website and get whatever version you need. Your IT would know which one you would need and they should be able to help you with all of this. Once I got the client I had to update the file called tsnames.ora. I had to change things like the server name, port, and some other stuff based on input from our IT department. My ODBC drivers reflect the information in tsnames.ora and the SAS code I use which looks something like this:

connect to odbc (dsn='xxxxx' uid=xxxxx pwd='xxxxxxxx');

create table tablexxxxxx as select * from connection to odbc (select * from ext.tablename);

Finally I suspect you'll need a TCP/IP connection to the server where the data are located. You need IT support for this I would think.

I think this might help. No guarantees Smiley Wink 

SAS Super FREQ
Posts: 8,744

Re: SAS University Edition: Can I access data in an MS SQL Server database?

Hi:

  I believe that the University Edition comes with SAS/Access to PC Files, per the key features shown on page 4 of this product information sheet:http://www.sas.com/content/dam/SAS/en_us/doc/factsheet/sas-university-edition-107140.pdf.

  I think that to use PROC SQL and a connection to ODBC you need SAS/Access to ODBC, as shown here in the Tech Support note about the System Requirements for using SAS/Access to ODBC 11077 - System Requirements for SAS/ACCESS to ODBC for SAS 9.1 on Windows64-bit platform. I do not think the University Edition comes with SAS/Access to ODBC -- it's not listed on the product fact sheet. You might have to investigate other ways of getting to your MS-Sql Server data, such as exporting the data from MS-Sql to one of the listed file types that can be easily read with SAS/Access to PC Files.

cynthia

Contributor
Posts: 32

Re: SAS University Edition: Can I access data in an MS SQL Server database?

Cynthia thanks for updating John, I wasn't aware of the limitation you mentioned in the University Edition.

New Contributor
Posts: 2

Re: SAS University Edition: Can I access data in an MS SQL Server database?

Cynthia,

I expect that you are correct, that is, University Edition does not support ODBC data sources. That's unfortunate for me, because my test data is in MS SQL-Server. I could export it to a spreadsheet, but that is inconvenient, onerous and doesn't help me build skills required for corporate environments. Still it's offered for free, so I'll have to accept the situations.

Thanks for your help.

Chris.

Ask a Question
Discussion stats
  • 4 replies
  • 1783 views
  • 5 likes
  • 3 in conversation