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 !
... View more
So you have a program that takes as input a filename X which contains a directory name (or set of directory names) that deletes files from those directories? So why not just make that program smart enough to NOT delete its input?
... View more
Ended up with this solution, including leading zeros, Thanks again ! %LET WEEK=W%sysfunc(week(%sysfunc(intnx(WEEK,%SYSFUNC(today()),0)),v),z2.); %put &=week; WEEK=W01
... View more
Solution turned out to be quite simple when I had help from Henrik Dorph SAS Institute DK. In all this excitement I lost track of how many connections I opened in the explicit pass-through and their alias names. You can both execute(...) by conn and Select from connection to conn in the same pass-through. But you must be care full with the connection alias (conn) and when they are 'open' proc sql; connect to oracle as dmw_conn(path = "(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=LSHTST)) (ADDRESS=(PROTOCOL=TCP) (HOST=132.240.154.71)(PORT=1521)))" user = "User" password = "Password" ); Create table test as Select * from connection to dmw_conn (SELECT * FROM zzz.xxx ); disconnect from dmw_conn; quit;
... View more
