topic Re: Reading Raw Data with the INPUT Statement in New SAS User

Reading Raw Data with the INPUT Statement

kfluegge — Thu, 15 Nov 2018 19:34:33 GMT

I am attempting to read raw data into SAS. I use the code below. It does not read correctly. I would like to find my error(s).

data days;
    infile datalines truncover;
    input x1 1-2 x2 3-10 x3 11 x4 12-13;
    datalines;
9	67.267	0	0
10	109.381	0	0
11	69.690	0	0
12	47.714	0	0
13	76.034	0	0
14	57.073	0	0
15	62.214	0	0
16	55.310	0	0
17	70.957	0	0
18	40.667	1	1
19	58.611	1	2
20	55.889	1	3
21	63.517	1	4
22	60.105	1	5
23	57.800	1	6
24	67.444	1	7
25	71.500	1	8
26	35.450	1	9
27	42.143	1	10
28	53.250	1	11
;

Re: Reading Raw Data with the INPUT Statement

Tom — Thu, 15 Nov 2018 19:39:10 GMT

So I copied and pasted what you posted and it looks like your data must have TAB characters in it instead of spaces.

Re: Reading Raw Data with the INPUT Statement

novinosrin — Thu, 15 Nov 2018 19:44:47 GMT

data days;
    infile datalines truncover ;
    input x1 1-2 x2 3-10  x3 12-13 x4;
    datalines;
9	67.267	0	0
10	109.381	0	0
11	69.690	0	0
12	47.714	0	0
13	76.034	0	0
14	57.073	0	0
15	62.214	0	0
16	55.310	0	0
17	70.957	0	0
18	40.667	1	1
19	58.611	1	2
20	55.889	1	3
21	63.517	1	4
22	60.105	1	5
23	57.800	1	6
24	67.444	1	7
25	71.500	1	8
26	35.450	1	9
27	42.143	1	10
28	53.250	1	11
;

SAS Output

The SAS System

x1	x2	x3	x4
9	67.267	0	0
10	109.380	0	0
11	69.690	0	0
12	47.714	0	0
13	76.034	0	0
14	57.073	0	0
15	62.214	0	0
16	55.310	0	0
17	70.957	0	0
18	40.667	1	1
19	58.611	1	2
20	55.889	1	3
21	63.517	1	4
22	60.105	1	5
23	57.800	1	6
24	67.444	1	7
25	71.500	1	8
26	35.450	1	9
27	42.143	1	10
28	53.250	1	11

Re: Reading Raw Data with the INPUT Statement

kfluegge — Thu, 15 Nov 2018 21:08:13 GMT

I changed the infile statement to that listed below. The output is a blank dataset. I do not think this resolves my problem.

infile datalines dlm=t dsd truncover;

Re: Reading Raw Data with the INPUT Statement

novinosrin — Thu, 15 Nov 2018 21:12:48 GMT

Not sure what your data is. I pasted a tested one using your sample. Is it not the one you provided?

Re: Reading Raw Data with the INPUT Statement

ballardw — Thu, 15 Nov 2018 21:43:26 GMT

@kfluegge wrote:

I changed the infile statement to that listed below. The output is a blank dataset. I do not think this resolves my problem.
infile datalines dlm=t dsd truncover;

t is not a tab character. Try dlm='09'x

The '09'x means to use the HEX value as an ASCII character and corresponds to the tab character.