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

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

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
  • 3184 views
  • 0 likes
  • 2 in conversation