Hi, I tryed to import some text based report as attach, my script to import is: data store (drop=Key0); infile "C:\Users\Administrator\Desktop\YULIA\sample.txt" delimiter = ' ' MISSOVER DSD LRECL=10000 pad; retain account_number date time amount type response thestore; /*input key1 $2-3 @; if key1 in ('3','4','5')then input @2 account_number2 $19.;*/ input @2 account_number $19. @22 Date ddmmyy8. @31 time $4. @36 amount $15. @53 type $8. @62 response $9. ; input key0 $52-59 @; if key0='THESTORE' then input @61 thestore $35.; format date date9.; if date ne .; run; my problem is the output missing some observation like below : account_number date time amount type response thestore 8-Jul-85 1210 999,800 RETAIL MORE WALLMART MMM 0000-8888-9999-7990 8-Jul-85 1210 790,000 RETAIL MORE PHILLIPS MMM 0000-8888-3333-7853 8-Jul-85 1240 969,955 RETAIL MORE WE HAVE ALL PRODUCT MMM the output should be like below : account_number date time amount type response thestore 0000-8888-9999-8896 8-Jul-85 1210 590,000 RETAIL MORE TIMEZONE MMM 8-Jul-85 1210 999,800 RETAIL MORE WALLMART MMM 0000-8888-9999-7990 8-Jul-85 1210 790,000 RETAIL MORE PHILLIPS MMM 0000-8888-3333-0697 8-Jul-85 1230 57,000 RETAIL MORE YOUR STORE AVAILABLE MMM 0000-8888-3333-7853 8-Jul-85 1240 969,955 RETAIL MORE WE HAVE ALL PRODUCT MMM have anyone any idea whats wrong with my code that causing missing some observation? thanks before.
... View more