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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.