SAS in not reading my last variable correctly

[daniel1986]

i have a huge data file, i inserted the names of all variables and i put the specifications for each variable, i.e. numeric or character or data

that is how my data originally are

b9916 023r2005031696277997Y0016562 1000000002060100200 DOSE PUMP S -1.001 PUFF(S) DISSO

b9916 023r2005031694748998Y0000011 28 0000002050501 TABLET(S) 1.55ONE EVERY NIGHT

b9916 023r2005031696940998Y0000002 28 0000002040000 TABLET(S) 1.001ONE EVERY DAY

b9916 023r2005031696329997Y0000021 56000000002060300 TABLET(S) 2.05TAKE ONE TWICE DAILY

b9916 023r2005031698776998Y0015362 28000000002090000 TABLET(S) 1.201 EVERY DAY WITH WATER WITH MEALS

b9916 023r2005031688958998Y0000005 28000000002050400 TABLET(S) 1.1 TAKE ONE DAILY



and here is how they appear in SAS

b9916 023r 3/16/2005 96277997 Y 0016562 1 0 0 0 02060100 200 DOSE PUMP S -1.00 1 PUFF(S) DISSO

b9916 023r 3/16/2005 94748998 Y 0000011 28 0 0 0 02050501 TABLET(S) 1.55 ONE EVERY NIGHT

b9916 023r 3/16/2005 96940998 Y 0000002 28 0 0 0 02040000 TABLET(S) 1.00 b9916 023r2005

b9916 023r 3/16/2005 98776998 Y 0015362 28 0 0 0 02090000 TABLET(S) 1.20 1 EVERY DAY WIT

b9916 023r 3/16/2005 88958998 Y 0000005 28 0 0 0 02050400 TABLET(S) 1.1 TAKE ONE DAILY

b9916 023r 4/12/2005 88958998 Y 0000005 28 0 0 0 02050400 TABLET(S) 1.00 TAKE ONE DAILY


if you notice the last variable in the third output took inputs from the third input and i am missing the fourth input in my data

so do any one have an idea of what is going on

Thanks

 

[klaz2002]

Can you show us the code that you created to read this data? I have a feeling I know why you get the results you describe.

Klaz

 

[sudhakode]

Using TRUNCOVER Option might help.