[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: Re : scan function with dsd option
From:       Walter Shafron <waltshaf () ABARE ! GOV ! AU>
Date:       2002-07-31 23:27:16
[Download RAW message or body]

what I have ended up doing is similar to some ideas suggested:

     input # linkv @1 ; * a specified line number;
     wholeline =_infile_;
     b=wholeline;
     _from='09'x||'09'x;  * tab tab;
     _to='09'x || ' ' || '09'x; * tab space tab;
     do until (b=oldb);
        oldb=b;
        b=tranwrd(oldb,_from,_to);
     end;

   amt=scan(b,6,'09'x); output;
ETC

because it was a wide file and many null values there were instances
of many tabs in a row.

Many thanks to all for suggestions.

Walter Shafron

[prev in list] [next in list] [prev in thread] [next in thread]