Reading the text file on remote server

mvk_sas — Thu, 16 May 2013 12:00:15 GMT

Hi All,

I need your help to overcome this issue

Lets say i have text file in unix server A and I was trying to read that file into other server where my actual code is located to create SAS dataset.

sample. txt is on unix server (host) 'abcd01'

I am running my sas code which converts this txt file as my dataset. (host=abcd01)

I did use this code below but no luck (I assume my servers use sftp connection)

filename myfile ftp 'data' cd='/u/kudzu/mydata'

user='guest' host='hp720.hp.sas.com'

recfm=v prompt;

data mydata / view=mydata; /* Create a view */

infile myfile;

input x $10. y 4.;

run;

proc print data=mydata; /* Print the data */

run;

NOTE : I dont want copy the files using ftp just wanted to read the file and create the dataset.

Any help is really appreciated!!

thanks

MVK

Re: Reading the text file on remote server

LinusH — Thu, 16 May 2013 12:59:44 GMT

If you need to use sftp, you have to specify that as connection method:

FILENAME Statement, SFTP Access Method :: SAS(R) 9.3 Statements: Reference

topic Reading the text file on remote server in SAS Procedures

Reading the text file on remote server

Re: Reading the text file on remote server