topic Re: Reading records spread over a varying number of lines in SAS Programming

Reading records spread over a varying number of lines

Brad5000 — Sun, 12 Jun 2016 14:29:30 GMT

Hi,

I'm trying to read values from a text file but unfortunately they're held in pretty weird format, for example the names 'Pete Smith' and 'John Brown' could be held like this;

name begin
pe
te
smi
th
end name
begin name
joh
n
br
o
wn
end name

Is it possible to read these into a dataset using a single input statement or would it need a combination of several inputs? Any advice would be appreciated.

Re: Reading records spread over a varying number of lines

Astounding — Sun, 12 Jun 2016 16:34:19 GMT

A DATA step could handle this except for one feature. How do you know when the first name ends and the last name begins?

Re: Reading records spread over a varying number of lines

Brad5000 — Sun, 12 Jun 2016 18:52:34 GMT

Hi, yes that's a problem, I think for now I would just like to get them into a single variable.

Re: Reading records spread over a varying number of lines

Astounding — Sun, 12 Jun 2016 22:57:37 GMT

OK, here's one way.

data want;

length name $ 30;

retain name;

length segment $ 20;

input segment &;

if segment='begin name' then name=' ';

else if segment='end name' then output;

else name = cats(name, segment);

run;

But the problem of identifying the separation point between first and last name still exists.

Re: Reading records spread over a varying number of lines

Ksharp — Mon, 13 Jun 2016 01:33:26 GMT

Attach a TEXT file to let us test it.

Re: Reading records spread over a varying number of lines

Kurt_Bremser — Mon, 13 Jun 2016 05:48:15 GMT

With data like that: impossible.

Simply because you cannot state a clear rule where words are separated; one coould only read in the names as strings without delimiters.

You first need a clear rule where the given name ends and the surname begins, then you can think about code.

The code would then actually be very simple.

Re: Reading records spread over a varying number of lines

Brad5000 — Mon, 13 Jun 2016 07:35:24 GMT

Thanks for that, works well with a Retain so is the best solution for now I think

data want;

length name $ 30;

length segment $ 20;

input segment &;
retain name;

if segment='begin name' then name=' ';

else if segment='end name' then 
   do;
      drop segment;
      output;
   end;
else name = cats(name, segment);



datalines;
begin name
pe
te
smi
th
end name
begin name
joh
n
br
o
wn
end name

run;

Re: Reading records spread over a varying number of lines

Brad5000 — Mon, 13 Jun 2016 07:39:24 GMT

Yes that is an issue, for now getting everything into a single variable will have to do.