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;
do
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!
... View more
