We have users running reports set up as stored processes from the SAS Add-in for Excel. Some reports needs to be saved to a location on a shared drive which is write-protected for the users. When users are running the reports, they fail with a 'Missing authorisation to save file' Error message. The reports runs and saves output just fine when executed by super-users with write access.
Is there a way to shift user prior to saving the output or to 'mask' the user as a machine account user when running the report in Excel ?
Thanks !