topic Re: reading in multiple obs per record from datalines in New SAS User

reading in multiple obs per record from datalines

hspears — Tue, 15 Dec 2020 17:12:40 GMT

Hi!

I want to read in the following datalines.

1 2 3

4 5 6

7 8 9

I am having trouble with the multiples observations per record. How do I account for the 3 space delimiter in between each observation?

Thank you!

Re: reading in multiple obs per record from datalines

Kurt_Bremser — Tue, 20 Oct 2020 15:17:20 GMT

Just use a double hold indicator in the INPUT statement:

data want;
input initial $ before after @@;
DATALINES;
H 11 14   H  1 10   H 10 18   J  3  2   
S  2 22   S  2 16   T  6 23   R  7  4   
;

Re: reading in multiple obs per record from datalines

ballardw — Tue, 20 Oct 2020 15:23:35 GMT

List input doesn't care how many delimiters there are by default, multiple delimiters, i.e. spaces, are treated as one "separation". If your actual data doesn't have the spaces now that would be a different question.