06-01-2015 01:23 AM
I have installed the SAS University Edition Unix based Virtual Machine on my Windows machine. Free Statistical Software, SAS University Edition | SAS
I executed proc setinit and confirmed that SAS/ACCESS Interface to ODBC is part of this
I have a SQL server on a windows machine and this is the same machine in which I have installed the SAS Univeristy edition virtual machine.
I have created a system dsn "SAS_DSN" though Control Panel-Administrative Tools-Data sources(ODBC) and ensured that SQL database connection is successful.
If I execute libname sql odbc dsn='sas_dsn'; I get an error message
ERROR: Could not load /opt/sasinside/SASHome/SASFoundation/9.4/sasexe/sasodb (104 images loaded)
ERROR: libodbc.so: cannot open shared object file: No such file or directory
ERROR: The SAS/ACCESS Interface to ODBC cannot be loaded. The SASODB code appendage could not be loaded.
ERROR: Error in the LIBNAME statement.
My guess is that the SAS virtual machine does not have ODBC drivers loaded.
Question: Is there any way we can download the ODBC drivers on the virtual machine? I suppose the SAS access iterface to ODBC is of no use without this
If anybody knows of any other way to connect to a database, let me know .I want to practise creation of SAS datasets from database tables
Thanks for your help
06-02-2015 01:50 PM
06-03-2015 09:20 AM
yes. University has it . But you can't modify it . If you have some Hacker friends, maybe they could help you something .
06-05-2015 02:29 AM
And get into big trouble with SAS. Reverse engineering the software is expressly prohibited in the License Agreement, and "software" here encompasses the whole VM image.
The UE is created for learning a very specific set of tasks. Anything more needs a suitable SAS installation and license; which is available at educational institutions that use SAS for statistic purposes.
06-05-2015 08:56 AM
In the cases where my data are stored in a database, I use R to join and extract data and write the results out to a CSV file. Total cost: $0.
06-06-2015 05:18 AM
Or simply unload the data with SQL from the RDBMS into a flatfile. Why not use the RDBMS when you have one, and tools like Squirrel are easily available if you don't want to deal with a full-blown database client.
06-04-2015 11:15 PM
Dear Beverly,Restonian and Xia,
The thread you posted was helpful and exactly as I imagined the problem to be. SAS set init procedure shows University Edition has the SAS/Access to ODBC but that is just the first step as it takes care of just the license and software component.. You also need the ODBC drivers for SQL corresponding on Unix Operating system that holds SAS when you invoke the SAS/Access interface through libname sql statement and this is something that is not present. and since the university edition is an image file there is no possibility of installing the ODBC drivers. Without ODBC drivers, SAS cannot search for the dsn specified in the libname sql statement