topic Re: reading two rows into a single observation in infile statement in SAS Programming

reading two rows into a single observation in infile statement

yemji — Fri, 07 Sep 2018 19:53:46 GMT

I have two rows read from a file with three variables as below
var1 var2 var3
a b
c

the output needs to be like dis
var1 var2 var3
a b c

Re: reading two rows into a single observation in infile statement

novinosrin — Fri, 07 Sep 2018 19:57:04 GMT

data have;
input var1 $ var2 $/ var3$;
cards;
a b
c
;

Re: reading two rows into a single observation in infile statement

PeterClemmensen — Fri, 07 Sep 2018 19:57:42 GMT

So your data looks like this, correct? Is this data actually representative of your data?

data have;
input var1 $ var2 $ var3 $;
infile datalines missover;
datalines;
a b
c
;

Re: reading two rows into a single observation in infile statement

yemji — Sat, 08 Sep 2018 03:01:38 GMT

nope this is how i am getting my output. i am trying to read a file im which first row contains data for first two observations and second row contains data for the third observation.

Re: reading two rows into a single observation in infile statement

novinosrin — Sat, 08 Sep 2018 03:04:43 GMT

first row contains data for first two observations or is it variables? did you test the code i gave you?

Re: reading two rows into a single observation in infile statement

yemji — Sat, 08 Sep 2018 03:10:18 GMT

sorry my bad its variables. let me try and get back