topic How to read records with missing data in SAS Programming

How to read records with missing data

Chikku — Wed, 29 Jan 2014 04:03:12 GMT

in the below prog,how can i enforce SAS to read the second line/record containing the missing data for A2,A4?which option is best to use(missover/truncover/flowover/deleteover)

data temp;

input A1 A2 A3 $ A4 mmddyy10. a5 percent6.;

cards;

1 3 retd 12/12/2009 56.32%

2 tujb 54.32%

;

run;

proc print data=temp;

run; i

Re: How to read records with missing data

data_null__ — Wed, 29 Jan 2014 04:11:23 GMT

What is the attribute of record 2 that tells you that A2 and A4 are missing?

Re: How to read records with missing data

art297 — Wed, 29 Jan 2014 04:49:24 GMT

If you will only be missing columns 2,4 and/or 5 the following might work:

data temp (drop=x dummy);

infile cards truncover;

informat a1 a2 12.;

informat a3 $8.;

informat a4 mmddyy10.;

format a4 mmddyy10.;

informat a5 percent6.;

x=0;

input a1 a2 @;

if missing(a2) then do;

input @1 dummy a3 a4 @;

x+1;

end;

else do;

input a3 a4 @;

end;

if missing(a4) then x+1;

if x gt 0 then do;

input @1 dummy @;

do _n_=2 to x;

input dummy @;

end;

input a5;

cards;

1 3 retd 12/12/2009 56.32%

2 tujb 54.32%

;

Re: How to read records with missing data

Peter_C — Thu, 30 Jan 2014 09:36:01 GMT

Before the input statement use

INFILE CARDS TRUNCOVER ;