Help using Base SAS procedures

How to export a csv/txt file

Reply
Contributor
Posts: 40

How to export a csv/txt file

hello,

I need help with exporting a .txt file from a remote unix server to windows server.

Would proc export does that? Please site an example/point to any existing code if available.

thanks!!

Frequent Contributor
Posts: 138

How to export a csv/txt file

which server your sas lies on? you can create a script to ftp.

Contributor
Posts: 40

How to export a csv/txt file

SAS is on Unix. I want to do it in SAS coding only. So finally I need to move a .txt file created on unix server to windows server. Thanks.

Regular Contributor
Posts: 233

How to export a csv/txt file

filename tranfile ftp 'tport.dat' lrecl=80 blocksize=8000

  recfm=f cd='mydir' host='myhost.mycompany.com'

  user='myuser' pass='mypass'

  rcmd='site umask 022 recfm=s';

http://support.sas.com/documentation/cdl/en/movefile/59598/HTML/default/viewer.htm#a001021283.htm

Contributor
Posts: 40

How to export a csv/txt file

I was using proc export and due to file size being very large, unable to get thru.

Proc download can also be used, but not sure if this works for infile/outfile references.

Ask a Question
Discussion stats
  • 4 replies
  • 321 views
  • 0 likes
  • 3 in conversation