Hello, we are currently creating large access db files on the window file server using PC SAS 9.2 by reading cpt files which are created on the mainframe and then transferred to windows file server. Now the organization is pushing to use SAS EG but it has limitations on creating access db on the unix server. Business users requires these files to be on the windows server. SAS EG has another option PC File server which requires a administration privileges on the laptop so that EG will treat the laptop as server and create the access db files but it's very hard to get admin rights. Is there any alternate solution?
SAS Enterprise Guide - the 32-bit version - can export data as Microsoft Access files: mdb file, the "old style" files. EG does this work (not SAS) and no additional software is needed.
The only other process I can suggest is to create CSV files with the data you need, and then use Microsoft Access scripts to create the database content from the CSV. It's a common practice, but it does add to the moving parts of your already complex flow.
Chris
@thirug wrote:
SAS EG has another option PC File server which requires a administration privileges on the laptop so that EG will treat the laptop as server and create the access db files but it's very hard to get admin rights.
I think you only need admin privileges to install PC File Server, not to run it each time. I would suggest talking to tech support on this issue.
I would also consider a text file as a workaround. I think an Access DB can be set up to pull from external data sources, including text files. So it's a bit of a work around but it should work.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.