I am running SAS University Edition release 3.4 on the Oralcle VirtualBox.
I am trying to set up a library linked to a MSAccess database with the following statement:
libname testDB pcfiles path="/folders/myfolders/some.mdb";
and get the following error:
Thanks. So I understand SAS/ACCESS is not available in SAS University Edition.
I assigned the above library using a SAS 9.4 Windows 64 bit install and created datasets:
* Run in SAS 9.4 Windows 64 bit ;
libname testDB pcfiles path="C:\some.mdb";
libname testLIB "C:\someDirectory";
data testLIB.testDATA; set testDB.testDATA; run;
The SAS datasets now exist in C:\someDirectory .
and then I assign that directory as a library in SAS University Edition ran a proc dataset statement to try to modify the datasets:
* In SAS University Edition;
proc dataset lib=testLIB;
modify testDATA;
I got the following error:
SAS UE is through a VM, which is Unix based, and you used Windows to create the files, causing the encoding issues.
If you're moving files between OS's I think the recommendation is to use XPORT or CPORT to transfer files.
If you still want to use your MS Access data in SAS UE you could export your data to a CSV file and use PROC IMPORT or a DATA step to read it.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.