reading NO Delimited Data

[Jaheuk]

dear all,

i have a file with NO delimiters.

I can read it in by using

input @001 xxx

        @010 yyyy

     ..........

but when there is a column added i need to re-calculate the positions :smileyconfused:

anyone an idea how to avoid this?

i start testing by using LENGTH or ATTRIB, informat, ...  before the input statement (possible with delimited data) . . . without any luck.

data have;

  attrib v1 lengt=$4  ....  v2 ....;

input v1 v2;

run;

GreetZ,

Herman

[Scott_Mitchell]

Can you provide some sample data?

[Jaheuk]

[Scott_Mitchell · Accepted solution]

It is hard to assume anything based on the volume of data you have provided.

Are the fields supposed to be fixed width?  If not, how do you know where each field ends?

The following should be pretty self explanatory.

data want;

infile datalines;

INPUT @1 var1 $2.

      var2 6.

      var3 $8.

;

datalines;

BE123456AAA

NL987654BBBBBBB

;

run;