topic Re: reading NO Delimited Data in SAS Programming

reading NO Delimited Data

Jaheuk — Wed, 28 Aug 2013 09:11:00 GMT

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 — Wed, 28 Aug 2013 09:25:38 GMT

Can you provide some sample data?

Jaheuk — Wed, 28 Aug 2013 09:48:37 GMT

Scott_Mitchell — Wed, 28 Aug 2013 10:30:09 GMT

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;