06-28-2014 02:29 AM
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.
06-28-2014 12:20 PM
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
06-28-2014 04:33 PM
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.
06-28-2014 09:33 PM
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.