# RE: st: quick question

 From "Martin Weiss" To Subject RE: st: quick question Date Wed, 17 Feb 2010 00:14:51 +0100

```<>

Eric: The "0" entry in the second row of your dataset counts as one for the
purposes of the -total- calculation with your code (which returns "9"),
which may or may not be what Tony wants...

HTH
Martin

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Eric Booth
Sent: Mittwoch, 17. Februar 2010 00:08
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: quick question

>
On Feb 16, 2010, at 3:38 PM, Lachenbruch, Peter wrote:
> I would like to be able to count the number of other_rashes

I *think* you are wanting to count the number of instances of each number in
"other_rash" even if there
are multiple instances per cell.   If so, here's one way to do it:
******************************
clear

input  str20 other_rash
"55.1"
"0"
"17.3;49.3"
"19.2;55.2;44.2;55;66"
end
replace other_ = trim(other_)
split other_, p(";")
egen rowtotal = rownonmiss(other_rash1-other_rash`=`r(nvars)''), strok
egen total = total(rowtotal)
******************************

~ Eric

__
Eric A. Booth
Public Policy Research Institute
Texas A&M University
ebooth@ppri.tamu.edu
Office: +979.845.6754

On Feb 16, 2010, at 3:38 PM, Lachenbruch, Peter wrote:

> I have a list of multiple diagnoses (rashes) and the typical one is quite
rare.  I decided to simply count the number of such diagnoses.  The data
look like (in the first 50 observations)
>
>     +--------------------+
>     |         other_rash |
>     |--------------------|
> 10. |               55.1 |
> 11. |                  0 |
> 12. |               54.3 |
> 13. |                  0 |
> 14. |                  0 |
>     |--------------------|
> 15. |               55.2 |
> 16. |                  0 |
> 17. |                  0 |
> 18. |          17.3;49.3 |
> 19. |               55.2 |
>     |--------------------|
> 20. |          11.3;18.3 |
> 21. |                  0 |
> 22. |                  0 |
> 23. |                  0 |
> 24. |      9.2;11.3;17.3 |
>     |--------------------|
> 25. |                  0 |
> 26. |                  0 |
> 27. |                2.1 |
> 28. |          15.2;23.2 |
> 29. |          19.2;55.2 |
>     |--------------------|
> 30. |                  0 |
> 31. |               11.2 |
> 32. |                  0 |
> 33. |                  0 |
> 34. |                  0 |
>     |--------------------|
> 35. |                  0 |
> 36. |                  0 |
> 37. |               57.2 |
> 38. | 7.1;11.2;29.2;55.3 |
> 39. |                  0 |
>     |--------------------|
> 40. |       2.2;5.3;39.3 |
> 41. |               18.2 |
> 42. |          11.3;24.3 |
> 43. |           5.2;55.2 |
> 44. |      9.3; 10; 57.2 |
>     |--------------------|
> 45. |               46.3 |
> 46. | 7.2;46.1;55.1;57.1 |
> 47. |                  0 |
> 48. |       5.2;9.2;15.2 |
> 49. |        3.2;7.2;9.2 |
>     |--------------------|
> 50. |                  0 |
>     +--------------------+
>
> I would like to be able to count the number of other_rashes - I tried to
find a string function that would do this count, I was unsuccessful.  Am I
missing something?  It's not crucial as I've already done this manually, but
I have several other variables to handle.
>
>
> Tony
>
> Peter A. Lachenbruch
> Department of Public Health
> Oregon State University
> Corvallis, OR 97330
> Phone: 541-737-3832
> FAX: 541-737-4001
>

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
```