tmp7day is as SAS libref that needs to be defined somewhere. It's either in code, in SAS metadata or in an autoexec. Try to find it.
A libref points to some physical location. My line of thought is to change the library definition so the path it points to is user specific.
Ideally you can change the libname definition in a central place. If that's not possible then something like below could also work.
Let's say the existing libref points to c:\temp
libname tmp7day "c:\temp";
You could as first step in your EG project re-point this library to a user specific folder. Code like below should work.
options dlcreatedir;
libname tmp7day "%sysfunc(pathname(tmp7day))\&sysuserid";
Just make sure to not execute above code more than once in an EG session or build some additional logic to prevent this libname to execute more than once in a SAS session. Code like below could do this.
%let sv_dlcreatedir=%sysfunc(getoption(dlcreatedir));
options dlcreatedir;
data _null_;
if find(pathname('tmp7day'),"&sysuserid",'i') <=0 then
do;
rc=libname('tmp7day',catx('\',pathname('tmp7day'),"&sysuserid"));
end;
run;
options &sv_dlcreatedir;
40 libname tmp7day list;
NOTE: Libref= TMP7DAY
.......
Filename= c:\temp\<and here the userid of the user that executes the script>
.......
Or if these tmp tables really only need to exist during a SAS session then re-point libref tmp7day to the SAS WORK library.
The SAS WORK library gets automatically created during SAS invocation and it points to a session specific folder location that gets created when SAS starts and that gets removed when SAS terminates.
Code like below would allow you to define an additional libref that also points to this WORK location.
libname tmp7day "%sysfunc(pathname(work))";
