topic Re: How do I extracting and sum across columns in SAS Programming

How do I extracting and sum across columns

ZeeM_31 — Tue, 20 Sep 2022 00:58:07 GMT

I'm working with a health survey data with twelve (12) columns/variables asking participants if they have different chronic health conditions. E.g.

Do you have Asthma: 1='Yes' 2='No' 6='Don't know' 7='Refusal'

Do you have hypertension: 1='Yes' 2='No' 6='Don't know' 7='Refusal'

I'm only interested in the number of health conditions that each participant has, so I'd like to create a new variable that extracts and sum all the 'Yes' and drop the other 12 variables.

I hope this makes sense; still new to SAS

Thank you!

Re: How do I extracting and sum across columns

Astounding — Tue, 20 Sep 2022 02:45:19 GMT

For an accurate answer, you need to supply a bit more information. What are the names of the 12 variables? What values do they take on? For example, are they numeric with possible values 1, 2, 6, or 7?

Here's a reasonable guess as to what the programming might look like.

data want;
  set have;
  array conditions {12} cond1 - cond12;
  n_conditions=0;
  do i=1 to 12;
     if conditions{i} = 1 then n_conditions + 1;
  end;
run;

Until we know more about how the analysis would proceed, I would advise against dropping any variables at this point.

Re: How do I extracting and sum across columns

ZeeM_31 — Tue, 20 Sep 2022 12:00:43 GMT

Thank you and yes, the columns are numeric variables with possible values of 1, 2, 6 & 7 with 1=Yes, 2=No etc. and I wanted to count the 1s

Something like this:

count of "1"

ID Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8................WANT

152 1 0 1 0 1 9 1 7 4

153 0 0 7 7 1 9 0 9 1

154 1 9 1 9 9 0 0 9 2

155 7 1 9 1 9 1 1 9 4

156 9 0 0 9 0 0 0 0 0

157 9 7 9 0 7 1 0 0 1

I found this in another thread which helped

data want;
   set have;
   countval = countc(cats(of col1-col13),'1');
run;

Thanks again