Hello, I am trying to figure out a file translation issue when using filename ftp. I have attached a sample of the file I have been trying to import. When I use the exact same data step code to import the exact same file I get bad results when I use the filename ftp (FTP Method below) versus good results when copying the same file (drag and drop) to the SAS server then importing from the copied file (Direct Copy Method below). I'm assuming the ftp messes it up because there are some encoding translation issues when pulling from a Windows FTP server to the Unix SAS Server. I've tried tweaking around with all the infile options but haven't been able get it to import everything. Sometimes it will even import a whole "column" of the data as a single attribute value. Does anyone know how I can get this to import to a table correctly (by correctly I mean having every bit of data in the table, the formatting can come later)? Thanks! /* FTP Method */
FILENAME ftpfiles FTP 'filename.txt'
CD='/directory'
HOST='host.com'
USER='user'
PASS='pass';
data _temp;
/* Exact same code */
infile ftpfiles
/* Exact same code */
run;
/* Direct Copy Method */
/* After copying file to sas server at '/sas_server/filename.txt' */
data _temp;
/* Exact same code */
infile ftpfiles '/sas_server/filename.txt'
/* Exact same code */
run;
... View more