https://communities.sas.com/t5/SAS-Procedures/Counting-variables/m-p/376100#M65375 Why thank you very much! This works fantastically! Fri, 14 Jul 2017 16:45:55 GMT lady8506 2017-07-14T16:45:55Z https://communities.sas.com/t5/SAS-Procedures/Counting-variables/m-p/376027#M65371 <P>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:</P><P>&nbsp;</P><P>Obs &nbsp; &nbsp; &nbsp; &nbsp;cares1 &nbsp; &nbsp; cares2 &nbsp; &nbsp; cares3 &nbsp; &nbsp; cares4</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4</P><P>2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3</P><P>3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; . &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; . &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P><P>5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; . &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1</P><P>6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;.</P><P>&nbsp;</P><P>What I would like to acheive is this:</P><P>&nbsp;</P><P>Obs &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NumEndor</P><P>1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4</P><P>2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P><P>3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3</P><P>4 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2</P><P>5 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3</P><P>6 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3</P> Fri, 14 Jul 2017 14:47:39 GMT https://communities.sas.com/t5/SAS-Procedures/Counting-variables/m-p/376027#M65371 lady8506 2017-07-14T14:47:39Z https://communities.sas.com/t5/SAS-Procedures/Counting-variables/m-p/376081#M65374 <P>Skip the loop and use the simple tool:</P> <P>&nbsp;</P> <P>NumEndOr&nbsp;= n(of cares1-cares4);</P> Fri, 14 Jul 2017 16:02:50 GMT https://communities.sas.com/t5/SAS-Procedures/Counting-variables/m-p/376081#M65374 Astounding 2017-07-14T16:02:50Z https://communities.sas.com/t5/SAS-Procedures/Counting-variables/m-p/376100#M65375 Why thank you very much! This works fantastically! Fri, 14 Jul 2017 16:45:55 GMT https://communities.sas.com/t5/SAS-Procedures/Counting-variables/m-p/376100#M65375 lady8506 2017-07-14T16:45:55Z