Hi
I have an access database which I need to open using SAS. This database has a macro set up that auto-runs queries once the password is entered. They can take up to half an hour. I then need to import the results.
My co-workers have told me it's impossible but i'm sure there must be some way to first open the database (using the x command?), then enter the password automatically, and finally wait till the database has ran before importing.
Does anyone have any ideas how i might go about this? Any help will be greatly appreciated.
Thanks.
Chris