topic Re: Array Code in SAS Procedures

Array Code

robertrao — Tue, 28 May 2013 00:22:49 GMT

Hi,

How can I scan through an array and put the last value of the array into another variable..

Have

value1 value2 value3 value4 value5 value6

xa xm bb

cc ad mn xy

xe an th ty pb kl

WANT:

new

Thanks

Re: Array Code

Haikuo — Tue, 28 May 2013 01:07:37 GMT

I suppose there maybe better approaches, but you can always do it reversely:

data have;

infile cards truncover;

input ( value1 value2 value3 value4 value5 value6) (:$2.);

array v value6 value5 value4 value3 value2 value1;

do over v;

if not missing (v) then do; new=v;leave;end;

end;

cards;

xa xm bb

cc ad mn xy

xe an th ty pb kl

;

Haikuo

UPdate: here is another option, better, in a way that you don't need to define array() elements explicitly.

data have;

infile cards truncover;

input ( value1 value2 value3 value4 value5 value6) (:$2.);

array v value:;

new=v(dim(v)-cmiss(of v(*)));

cards;

xa xm bb

cc ad mn xy

xe an th ty pb kl

;

Re: Array Code

robertrao — Tue, 28 May 2013 01:21:56 GMT

Thanks Hi,

Unfortunately ,the system is not showing the Correct option..I will update it a lil later

Regards

Re: Array Code

robertrao — Tue, 28 May 2013 01:24:10 GMT

hi,

I was curious why did you put the array items in the reverse order in the first method????????/

Thanks

Re: Array Code

Haikuo — Tue, 28 May 2013 01:38:52 GMT

So when looping through array, it starts from value6 to value1. Of course you don't have to do that, cause you can always loop it from the END to START, it didn't occur to me until I posted up.

Re: Array Code

robertrao — Tue, 28 May 2013 01:46:21 GMT

I was thinking if array goes from end to start it would give us

new

Thnkx