BookmarkSubscribeRSS Feed
mvk_sas
Calcite | Level 5

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

1 REPLY 1
LinusH
Tourmaline | Level 20

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

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 3130 views
  • 0 likes
  • 2 in conversation