topic SAS EG - Creating large access db in SAS Enterprise Guide

SAS EG - Creating large access db

thirug — Wed, 18 Oct 2017 18:06:47 GMT

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?

Re: SAS EG - Creating large access db

ChrisHemedinger — Wed, 18 Oct 2017 18:38:19 GMT

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

Re: SAS EG - Creating large access db

Reeza — Wed, 18 Oct 2017 18:49:36 GMT

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

Re: SAS EG - Creating large access db

LinusH — Fri, 20 Oct 2017 10:32:01 GMT

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.