topic How to read MS Access database table into mainframe SAS? in SAS Programming

How to read MS Access database table into mainframe SAS?

pheynix — Mon, 01 May 2017 20:41:01 GMT

Does anyone know how to read a MS Access database table into SAS for mainframe? Is it best to export data to the desktop and then FTP the MS Access data into a mainframe dataset for mainframe SAS to read in? Or is there syntax I can use in a mainframe SAS program that would allow me to read the table directly when I run my mainframe SAS program?

Re: How to read MS Access database table into mainframe SAS?

ChrisNZ — Tue, 02 May 2017 01:21:25 GMT

Can you read it using SAS PC and proc upload the data set?

Re: How to read MS Access database table into mainframe SAS?

pheynix — Thu, 04 May 2017 01:19:53 GMT

Thank you! Do you (or does anyone reading this) know of some sample syntax for the proc upload to get the table into mainframe?

Re: How to read MS Access database table into mainframe SAS?

pheynix — Thu, 04 May 2017 12:27:20 GMT

Or do I even need to use proc import at all? Can I just define a library in my mainframe SAS code, something like this?

LIBNAME mydata ACCESS PATH='c:\myaccessdb.accdb';