On Mar 9, 11:27 am, iebup...@GMAIL.COM ("./ ADD NAME=Data _null_;") wrote: > I think all the formats need the : modifier or use INFORMAT statement. > FORMATED input "var06 data11." is incompable with this type of input. > > On 3/9/09, Joe Matise <snoopy...@gmail.com> wrote: > > > As far as I understand it, that's what DSD does... perhaps take off the : > > from your informats, not sure if they might be causing trouble? > > > -Joe > > > On Mon, Mar 9, 2009 at 9:00 AM, jwc <jwcass...@earthlink.net> wrote: > > > > I'm trying to read a pipe-delimited ascii file using the following > > > code: > > > > data temp; > > > infile 'C:\shp\State_active_memb_200902031517.txt' DLM='|' DSD > > > lrecl=300 TRUNCOVER ; > > > > input var01 :$12. > > > var02 :$12. > > > var03 :$12. > > > var04 :$9. > > > var05 date11. > > > var06 date11. > > > var07 date11. > > > var08 date11. > > > var09 :$1. ; > > > run; > > > > Consecutive pipe characters (||) are skipped over instead of being > > > read as missing values. Can anyone point me in the right direction? > > > > Thanks, > > > James

Yup, need the colon on all the variables. Thanks folks.

James