Array Concept

robertrao — Tue, 28 May 2013 01:37:30 GMT

Hi,

Yet an other Array Question..

If the in: and out: is missing then I want to set the dept: to missing too

In the below example since in2 and out2 are missing dept2 dept2_2 must be missing

Same with Dept3 and Dept3_3

in1 out1 dept1 dept1_1 in2 out2 dept2 dept2_2 in3 out 3 dept3 dept3_3

28Dec 30dec CM CM . . DM DM . . PM PM

WANT:

in1 out1 dept1 dept1_1 in2 out2 dept2 dept2_2 in3 out 3 dept3 dept3_3

28Dec 30dec CM CM . . . . . . . . .

Thanks

Re: Array Concept

Tom — Tue, 28 May 2013 04:15:15 GMT

Just loop over the array as in your other examples.

data want;

set have;

array in in1-in3;

array out out1-out3;

array d1 dept1-dept3 ;

array d2 dept2_1 - dept2_3 ;

do i=1 to dim(in);

if 0=n(in(i),out(i)) then do; d1(i)=' ',d2(i)=' '; end;

end;

run;