If your IT department is slow to set things up and assuming you can read the access files from your PC and are somewhat comfortable with R, you can: 1) install R on your PC 2) install the R RODBC package 3) Write R code to read the access files and save to a format that SAS can read (try Haven package write_SAS() or write.foreign which creates .CSV files and the SAS code to read them: https://www.rdocumentation.org/packages/foreign/versions/0.8-74/topics/write.foreign) If you have SAS installed on a server and you happen to have R installed on the same server, you could see if you can get the RODBC package installed and then in step 3 you could write SAS IML code to call R, read the access data with the RODBC package, and then have IML copy the R object with your access data to a SAS data set; obviating the need to create text files and such. PCFiles would probably be simpler to do. I only suggest the above if time is essential. We ended up purchasing a 3rd party ODBC driver to allow us to read and write access using SAS proc SQL. I wish SAS would provide their own native support for MS access like they do with MS excel (sort of.)
... View more