My office are currently upgrading from SAS 9.1 to SAS 9.3. I'm having an issue posting a .csv file to an FTP site using the code below. When using 9.1 everything works perfectly, but on 9.3 the .csv file is posted to the FTP site but remains empty, the data is not printed into the file and the program continues runnig perpetually even though the data set being tested is incredibly small.
From what I can tell everything works right up until the proc print statement. Has anyone seen this issue before or have any idea how I might resolve it?
Thanks for your help in advance.
rsubmit;
data test;
input v1 $5. v2 v3 date9.;
datalines;
Test1 1 01JAN2001
Test2 2 02FEB2002
Test3 3 03MAR2003
Test4 4 04APR2004
Test5 5 05MAY2005
;
endrsubmit;
rsubmit;
filename myftp ftp "/WEB_TEMP/Test/Test_30OCT2015.csv"
host= "host"
user= "user"
pass= "password";
ods listing close;
ods csv file=myftp;
Proc Print Data= test noobs;
var v1 v2 v3;
run;
ods csv close;
ods listing;
filename myftp clear;
endrsubmit;
Try testing just the FTP by itself without ODS. Does it give you the same result?
Hi SASKiwi,
Thanks for the reply. I have tested the code without ODS and I get the same result. I suspect it's not actually a coding error but possibly an issue with 9.3 itself or some of the behind-the-scenes working that I'm not too clued up on.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.