Help using Base SAS procedures

Counting variables

Accepted Solution Solved
Reply
Contributor
Posts: 24
Accepted Solution

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: 5,500

Re: Counting variables

Skip the loop and use the simple tool:

 

NumEndOr = n(of cares1-cares4);

View solution in original post


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

Re: Counting variables

Skip the loop and use the simple tool:

 

NumEndOr = n(of cares1-cares4);

Contributor
Posts: 24

Re: Counting variables

Posted in reply to Astounding
Why thank you very much! This works fantastically!
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 146 views
  • 1 like
  • 2 in conversation