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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.