Using array to sum across columns with condition

stephneepa — Wed, 30 Jun 2021 19:10:27 GMT

Hello,

I have a dataset that includes the frequency that participants did 94 different activities in the past 30 days (1 frequency variable for each activity, each on a 0-4 scale) as well as an additional 94 variables indicating where each activity took place (1=indoors, 2=outdoors, 3=NA if the activity was not done). I would like to aggregate across this information so that I have an aggregate indicator of how often outdoor activities were done, incorporating both the number of outdoor activities as well as how often each of these was done.

I am a little rusty on use of arrays. I tried to create arrays for the 94 frequency and 94 activity variables; my ultimate goal is to calculate a SUM of all thearrays, sum across columns frequency variables for which the participant indicated the activity was typically done outdoors (so, a sum function but including only those activities where the corresponding where variable = 2).

This is what I have for code below, but based on the aggregate value coming out, I don't think it is working correctly. Any ideas? Thank you!

data bl;
set go.bl;
*Create an array of all the WHERE variables;
array actwhere {94} Ac1WatchTVwhere Ac1WatchMovieHomewhere [etc... each of these is a variable that shows the frequency the participate did a given activity, e.g. the first one here where they typically watched TV 1=indoors, 2=outdoors, 3=NA; I'm not going to list out all 94 here because it makes this hard to read]

*Create an array of all the FREQ variables;
array actfreq {94} Ac1WatchTVfreq Ac1WatchMovieHomefreq [etc... again listing all 94 of these variables, which indicate the frequency of each activity on the 0-4 scale]

do i = 1 to 94;

if actwhere{i} = 2 then do; *Trying to isolate activities done outside here before summing;
act_outdoor_freq=sum(of actfreq{i}); *Trying to create a new aggregate variable that is the sum of the frequencies of all those activities done outside;
end;

end;
run;

Re: Using array to sum across columns with condition

PaigeMiller — Wed, 30 Jun 2021 19:26:25 GMT

act_outdoor_freq=0;
do i = 1 to 94;
    if actwhere{i} = 2 then act_outdoor_freq=sum(act_outdoor_freq,actfreq{i}); 
end;

Re: Using array to sum across columns with condition

Reeza — Wed, 30 Jun 2021 20:09:15 GMT

FYI - if you restructure your data to a long format these types of questions are much easier to answer.

topic Re: Using array to sum across columns with condition in SAS Programming

Using array to sum across columns with condition

Re: Using array to sum across columns with condition

Re: Using array to sum across columns with condition