Hello,
The aim of this code is just to get create a log file in the unix location but I've been getting this error.
These are the steps I've taken so far:
1. I checked the shared unix path to make sure I have access
2. Made sure the unix path is written correctly
3. made sure the folders were created and had read write rights.
4. I even created a dummy document but nothing seems to get rid of this error and the log displays nothing useful, just the below statements all over again.
All the posts in this forum regarding this error were mainly due to its usage in infile statement, so I couldn't find anything similar.
Would appreciate some help
filename pswrdfile "some password file location" ;
data _null_ ;
infile pswrdfile truncover;
input line :$50.;
call symputx('dtbspswrd',line);
run ;
%put & dtbspswrd ;
%let unix_path = some unix path location;
proc printto log = "&unix_path./log/prjname_log.txt";
run;
options nocenter source2 mlogic symbolgen nomprint;
Proc SQL;
CONNECT TO teradata (user="%sysget(USER)" password="& dtbspswrd." tdpid=aprtera mode=teradata);
CREATE TABLE def as
Select * From connection to teradata
(SELECT top 10 * FROM some_table);
DISCONNECT FROM TERADATA;
QUIT;
proc contents data= def;
run;
proc printto; run;
Adding log:
GOPTIONS ACCESSIBLE;
filename pswrdfile "some password file location" ;
data _null_ ;
infile pswrdfile truncover;
input line :$50.;
call symputx('dtbspswrd',line);
run ;
NOTE: The infile PSWRDFILE is:
Filename = some password file location,
Owner Name = [my user id], Group Name = sasuser2,
Last Modified = 06Dec2018;11:36:54,
File Size (bytes) = 40
NOTE: 1 record was read from the infile PSWRDFILE.
The minimum record length was 40.
The maximum record length was 40.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
%put & dtbspswrd ;
SYMBOLGEN: Macro variable DTBSPSWRD resolves to {Encrypted password}
%let unix_path = some unix path location;
proc printto log = "&unix_path./log/prjname_log.txt";
SYMBOLGEN: Macro variable UNIX_PATH resolves to 'some unix path location'
run;
ERROR: Physical file does not exist, some unix path location/log/prjname_log.txt
NOTE: The SAS System stopped processing this step because of errors.
options nocenter source2 mlogic symbolgen nomprint;
Proc SQL;
CONNECT TO teradata (user="%sysget(USER)" password="& dtbspswrd." tdpid=aprtera mode=teradata);
CREATE TABLE def as
Select * From connection to teradata
(SELECT top 10 * FROM some_table);
NOTE: Table WORK.DEF created, with 13 rows and 700 columns
DISCONNECT FROM TERADATA;
QUIT;
NOTE: PROCEDURE SQL used (Total process time):
real time 15.30 seconds
cpu time 0.04 seconds
proc contents data= def;
run;
proc printto; run;
