Last row of text file

[RW9]

Thanks for the post Tom.  Yes, holding the pointer over might work.  The problem is that the data is coming from a large database organization, so we will have many databases, with different strucutures.  Even if I had the time to go through each and check what fields this happened in and code around the issue, it should have been noted/fixed before.  So I have a ticket in with SAS Support, and I will get back to the DB supplier to see why these specials are being sent in the first place.  Not my job to fix commericial products :smileylaugh:

[RW9 · Accepted solution]

Hi,

Just to finalise this post.  Support sent me some code posted below, which is working for me as an intermediary setup.

data _null_;

     infile "s:\temp\rob\x.csv" recfm=n;

     file "s:\temp\rob\y.csv" recfm=n;

     retain Flag 0;

     input a $char1.;

     if a = '"' then

         if Flag = 0 then

             Flag = 1;

         else

             Flag = 0;

     if Flag = 1 then

         do;

         if a = '0D'x then

             do;

             goto exit;

             end;

         if a = '0A'x then

             do;

             goto exit;

             end;

         end;

     put a $char1.;

EXIT:

run;