BookmarkSubscribeRSS Feed
jbennett
Calcite | Level 5

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;

 

2 REPLIES 2
SASKiwi
PROC Star

Try testing just the FTP by itself without ODS. Does it give you the same result?

jbennett
Calcite | Level 5

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-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 737 views
  • 0 likes
  • 2 in conversation