SAS EG - Creating large access db

[thirug]

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?

[ChrisHemedinger]

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

[Reeza]

---

@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. 

[LinusH]

Sorry but why are we talking about a PC Files Server on a laptop?
In my mind you set it up on a Windows Server which is reachable from your SAS Workspace Server session.