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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: