Help using Base SAS procedures

Reading the text file on remote server

Reply
Occasional Contributor
Posts: 12

Reading the text file on remote server

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.

Ex

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

Super User
Posts: 5,441

Re: Reading the text file on remote server

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

Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 686 views
  • 0 likes
  • 2 in conversation