topic Re: datalines in SAS Programming

datalines

helloSAS — Sat, 16 Mar 2013 05:18:49 GMT

I'm not able to read the below datalines corretly. I want the table to look just like it appears in the datalines (i.e., missing values in field 3 for row 3 and 4).

data x;

infile datalines dlm=' ' dsd;

input scode field2 field3 field4;

datalines;

2 23 34543 233409

3 24 34569 800380

5 45 098873

8 33 093872

;

run;

Please suggest the currect answer.

Re: datalines

dipun — Sat, 16 Mar 2013 09:37:28 GMT

Hello Friend,

in this table all variable are in numerical so you have to represent a period (a dot) for missing value.

data x;

input score field2 field3 field4;

datalines;

2 23 34543 233409

3 24 34569 800380

5 45 198873

8 33 093872

;

run;

try this also...

if you want to missing value then you can use $ sign...

data x;

input score field2 field3 $5. field4;

datalines;

2 23 34543 233409

3 24 34569 800380

5 45 198873

8 33 093872

;

run;

Thanks

Re: datalines

Peter_C — Sat, 16 Mar 2013 11:09:30 GMT

As these datalines are in a fixed layour no need to use DSD or delimiters

Inpit a 1. B 3. C 6. D 6. ;