Hello,
I have a STP which runs under the sassrv technical user. With the follwing x-command I create a list of all work-directories with a certain table inside of them and then want to import it as a table. When I run the code as another user it works fine, but with the sassrv user nothing gets imported.
Coding:
x "find &workpath. -name &tableName..sas7bdat > &workpath./work_directories.txt";
proc Import datafile="&workpath./work_directories.txt"
out=work.work_finding_1
dbms=dlm
replace;
getnames=NO;
run;
Result when I run the coding with my user:
NOTE: The infile '/work_p/work_directories.txt' is:
Filename=/work_p/work_directories.txt,
Owner Name=XXXXXXX,Group Name=XXXXXX,
Access Permission=-rw-r--r--,
Last Modified=16Sep2019:10:38:22,
File Size (bytes)=81
NOTE: 1 record was read from the infile '/work_p/work_directories.txt'.
The minimum record length was 80.
The maximum record length was 80.
NOTE: The data set WORK.work_finding_1 has 1 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
Result when sassrv runs the same code:
NOTE: The infile '/work_p/work_directories.txt' is:
Filename=/work_p/work_directories.txt,
Owner Name=sassrv,Group Name=sas,
Access Permission=-rw-r--r--,
Last Modified=16. September 2019 10.38 Uhr,
File Size (bytes)=81
NOTE: 0 records were read from the infile '/work_p/work_directories.txt'.
NOTE: The data set WORK.WORK_finding_1 has 0 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
Content of the txt File:
/work_p/SAS_work1D9C015D00B6_macdb001/SAS_work0994015D00B6_macdb001/aa1.sas7bdat
I am completly lost as to why this is happening.
Any help would be greatly welcomed
Kind Regards
Criptic
... View more
