topic FTP help - EG 4.1 in SAS Enterprise Guide

FTP help - EG 4.1

deleted_user — Wed, 05 May 2010 15:51:08 GMT

Hello,

Need some help. I'm using the below code to send a file to an FTP server. What I need to do is to send the data TAB delimited. Is this possible?

An alternative, is to export the data to a tab delimited file to my C:\ drive, and then send that file in the FTP transfer? Is this possible, and if so, what is the correct syntax to reference an external file to be sent?

filename CUSTDATA ftp 'PREV_WK_CUST_DATA.csv' cd='/VINData'
host='9999999'
user='xxxxx' pass='xxxxxx'
recfm=s
DEBUG;
run;
ODS LISTING CLOSE;

ODS CSV body=CUSTDATA trantab=ascii;

proc print data=WORK.PREV_WK_CUST_DATA noobs;
run;

ODS CSV CLOSE;
run;
ODS LISTING;
run;

Re: FTP help - EG 4.1

ChrisHemedinger — Sat, 08 May 2010 01:05:15 GMT

Are you asking whether your current program approach will work when run within Enterprise Guide? It should...

Chris

Re: FTP help - EG 4.1

deleted_user — Mon, 10 May 2010 14:46:45 GMT

no, i know the above works. What i need to do is to create a TAB delimited file OR FTP an file that resides on my C drive. Is this possible, and if so how?

Re: FTP help - EG 4.1

Doc_Duke — Mon, 10 May 2010 15:28:37 GMT

To create the TAB delimited ODS CSV output requires changing the ODS Template for CSV. You should find instructions here
http://support.sas.com/rnd/base/ods/odsmarkup/index.html
(I've not tried it).

To directly FTP a file requires that you use the 'x' command and use the operating system FTP; the 'x' command is disabled by default in EGuide. Your administrator would have to enable that for you. There are a number of discussions of 'x' elsewhere on this forum.

Re: FTP help - EG 4.1

Cynthia_sas — Mon, 10 May 2010 15:38:20 GMT

Hi:
ODS CSV (in some versions) does have the delimiter= suboption:
[pre]
ods csv file=fileref_out options(delimiter='*' doc="Help");
[/pre]

For more information, see
http://support.sas.com/forums/thread.jspa?threadID=5414

I believe that on Windows systems, the tab character (in hex) is '09'x...so the appropriate ODS CSV statement would be:

[pre]
ods csv file=fileref_out options(delimiter='09'x doc="Help");
[/pre]

cynthia