Solved
Contributor
Posts: 37

# Counting variables

I have some variables that I need to count up so long as the observation for them is not missing. I'm trying to do it in a loop. Can someone help me figure this out, please? Here is some sample data:

Obs        cares1     cares2     cares3     cares4

1                 2              1            0              4

2                 1              1            1              3

3                 3              2            4              .

4                 .               .             0              0

5                 4             0             .               1

6                 1             2             0              .

What I would like to acheive is this:

Obs           NumEndor

1                       4

2                       4

3                       3

4                       2

5                       3

6                       3

Accepted Solutions
Solution
‎07-14-2017 12:45 PM
Super User
Posts: 6,789

## Re: Counting variables

Skip the loop and use the simple tool:

NumEndOr = n(of cares1-cares4);

All Replies
Solution
‎07-14-2017 12:45 PM
Super User
Posts: 6,789

## Re: Counting variables

Skip the loop and use the simple tool:

NumEndOr = n(of cares1-cares4);

Contributor
Posts: 37