topic Re: Writing to Pipe delimited - error 'some output data maybe lost because dropover option was speci in SAS Programming

Writing to Pipe delimited - error 'some output data maybe lost because dropover option was specified

LOLO — Thu, 02 Aug 2018 17:51:52 GMT

Hi, I have used this code to write to a pipe delimited file so many times and for some reason today it will not work on a data set. I get the error 'Some output data may be lost because DROPOVER option was specified.' So out of 200,000 records it only outputs 2 records.

%let outfile=want;

data _null_;

%let _EFIERR_=0;

%let _EFIREC_=0;

file "&outfile." DSD delimiter='|' DSD DROPOVER lrecl=32767;

if _n_=1 then do;

put

"var1"

'|'

"var2"

'|'

"var3"

'|'

"varN"

; end;

set have end=EFIEOD;

format var1 $4.;

format var2 $6.;

format var3 best12.;

format varN best12;

EFIOUT +1;

put var1 $@;

put var2 $@;

put var3 @;

put varN @;

end;

if _ERROR_ then call symputx('_EFIERR_',1);

if EFIEOD then call symputx('_EFIREC_',EFIOUT) ;

run;

I cannot figure out what I am doing wrong. Any thoughts?? Anyone else seen this error? THANKS!

Re: Writing to Pipe delimited - error 'some output data maybe lost because dropover option was speci

ballardw — Thu, 02 Aug 2018 18:03:46 GMT

@LOLO wrote:

Hi, I have used this code to write to a pipe delimited file so many times and for some reason today it will not work on a data set. I get the error 'Some output data may be lost because DROPOVER option was specified.' So out of 200,000 records it only outputs 2 records.

%let outfile=want;

data _null_;

%let _EFIERR_=0;

%let _EFIREC_=0;

file "&outfile." DSD delimiter='|' DSD DROPOVER lrecl=32767;

I cannot figure out what I am doing wrong. Any thoughts?? Anyone else seen this error? THANKS!

Are you attempting to have 4 variables on one line or keep stacking them across the output file until the lrecl is filled?

Perhaps missing a final put; to end the line?

Re: Writing to Pipe delimited - error 'some output data maybe lost because dropover option was speci

LOLO — Thu, 02 Aug 2018 18:14:20 GMT

I would like the variable names listed across the top - so for simplicity sake 4 rows. My actual data has 265 variables and 200,000 records. Am I missing a 'put?' When I look at the txt file it creates it looks like a 'flowover' so the second records starts on the same line as the first record.

Re: Writing to Pipe delimited - error 'some output data maybe lost because dropover option was speci

LOLO — Thu, 02 Aug 2018 19:02:38 GMT

I figured it out! That last @ in the put statements causes the carriage return. Once I remove it works 🙂