Hi there, Sounds trivial? but I have been having problems reading files If I invoke the drop down fucntionality unders files -> import data and point to a location and try reading the files I have no problems and it generates the following code: DATA WORK.test_for_sas2; LENGTH name $ 3 acc_no 8 ; FORMAT name $CHAR3. acc_no BEST1. ; INFORMAT name $CHAR3. acc_no BEST1. ; INFILE 'E:\saswork\_TD7416\#LN00368' LRECL=5 ENCODING="WLATIN1" TERMSTR=CRLF DLM='7F'x MISSOVER DSD ; INPUT name : $CHAR3. acc_no : ?? BEST1. ; RUN; To me it seems that SAS internally copies the file to our SAS server (EG) and reads it in, but If i change the infile statement from above to point to server location where I want to read from (for automation purposes) e.g. infile '\\sdax.server.ca\sftp_read\file.csv' it gives me an I/O error. I am stumped. This server location is an SFTP folder for our vendors to drop the csv. I want to automate the process of reading the files, but can't do so. Would you have an idea , how to read it in? I can't use windows shell command to copy (as this functionality in SAS EG is disabled and our admin won't allow this) the files to another location and read it in. BTW if I copy this file to our SAS EG server location and point to that location using infile statement, SAS works and reads the file, So I am guessing it is some sort of the settings on this folder /server which is preventing SAS to read. Please help ? Thanks, PD
... View more