DATA Step, Macro, Functions and more

reading NO Delimited Data

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 89
Accepted Solution

reading NO Delimited Data

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


Accepted Solutions
Solution
‎08-28-2013 06:30 AM
Super Contributor
Posts: 297

Re: reading NO Delimited Data

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;

View solution in original post


All Replies
Super Contributor
Posts: 297

Re: reading NO Delimited Data

Can you provide some sample data?

Frequent Contributor
Posts: 89

Re: reading NO Delimited Data

sas.bmp

Solution
‎08-28-2013 06:30 AM
Super Contributor
Posts: 297

Re: reading NO Delimited Data

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;

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 212 views
  • 0 likes
  • 2 in conversation