topic Re: How to create a count variable in SAS Studio

How to create a count variable

Rashis — Fri, 13 Apr 2018 21:15:36 GMT

Hi, I have a dataset with multiple categorical variables for different comorbidities of patients like arthritis, highbp, heartdisease etc. I need to create a count variable to see the exact number of comorbidities each person has. So for eg: if arthritis =1 then count =1 , then if they have heartdisease too then count should be 2 etc...

I am new to SAS can someone help me with this?

Thanks

Rashi

Re: How to create a count variable

art297 — Fri, 13 Apr 2018 21:26:46 GMT

The answer is going to be different depending upon how your data are organized.

Post an example of your data (in the form of a datastep) and what you'd like your resulting file to look like.

Art, CEO, AnalystFinder.com

Re: How to create a count variable

Rashis — Fri, 13 Apr 2018 21:36:07 GMT

record_id arthritis hypertension heartdisease emphysema chroniclung

1 0 0 1 1 1

2 1 1 0 0 0

3 0 0 0 0 0

so record_id is each patient and these a re all the comorbidities for each patient.

I want a variable , say count which counts the exact number of comorbidities each person has

so for the record_id =1 the count should be =3(heartdisease, emphysema and chronic lung)

2 count=2

3 count=0 etc...

Thanks!

Re: How to create a count variable

art297 — Fri, 13 Apr 2018 21:50:43 GMT

Here is one way:

data have;
  input record_id arthritis hypertension heartdisease emphysema chroniclung;
  cards;
1                   0                           0                    1                       1               1
2                   1                           1                     0                       0               0
3                    0                           0                     0                     0                0
;

data want;
  set have;
  count=countc(catt(of arthritis--chroniclung),'1');
run;

Art, CEO, AnalystFinder.com

Re: How to create a count variable

ballardw — Fri, 13 Apr 2018 21:59:59 GMT

And another

data want;

set have;

count = sum( of arthritis--chroniclung);

run;

Re: How to create a count variable

joelee1 — Thu, 01 Jul 2021 13:37:55 GMT

Is there a way to do this for a large dataset where I cannot enter in all the data? Thanks!

Re: How to create a count variable

PaigeMiller — Thu, 01 Jul 2021 13:59:16 GMT

The response from @ballardw above should work for any size data set.