topic Re: SAS Array coding in SAS Programming

SAS Array coding

knargis160 — Tue, 11 Feb 2020 21:07:44 GMT

I have dataset with

who_reacted_1 who_reacted_2----so on

1. 5556 5555

I want to calculate total number of who_reacted-like for first it should be 2

who_reacted_1 they all are character.

data testing_nreact; set redcap;
array whoreact(*) who_reacted_1-who_reacted_40;
  do i=1 to 40;
  n_reaction=0;
  sum_nreactions =sum(of whoreact[*]);
  end;
run;

Can anyone help with code??

Re: SAS Array coding

PaigeMiller — Tue, 11 Feb 2020 21:11:33 GMT

I cannot understand this sentence at all: "I want to calculate total number of who_reacted-like for first it should be 2 who_reacted_1 they all are character."

Can you please explain further? And maybe provide an example with more than one data point?

Re: SAS Array coding

jklaverstijn — Tue, 11 Feb 2020 21:20:02 GMT

If you mean you want to count the number of reactions instead of their sum, replace this lien

sum_nreactions =sum(of whoreact[*]);

with

num_reactions =n(of whoreact[*]);

The N() function counts the number of non-missing values.

Hope this helps,

- Jan.

Re: SAS Array coding

ballardw — Tue, 11 Feb 2020 21:45:44 GMT

@jklaverstijn wrote:

If you mean you want to count the number of reactions instead of their sum, replace this lien
sum_nreactions =sum(of whoreact[*]);
with
num_reactions =n(of whoreact[*]);
The N() function counts the number of non-missing values.

Hope this helps,

- Jan.

AND doing either of Sum(of whoreact[*]) or N(of whoreact[*]) in a loop is completely unneeded. Unless you really want to sum/count the same things 40 times to get the one result.

Re: SAS Array coding

knargis160 — Fri, 14 Feb 2020 09:59:43 GMT

Thanks it worked.

Can you also explain how should change the n(of whoreact[*]) if the participant should be (55-60)