Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

# st: RE: quick question

 From "Nick Cox" To Subject st: RE: quick question Date Wed, 17 Feb 2010 11:27:52 -0000

```Standing on everyone else's shoulders, a one-line solution appears to be

gen hashrash = cond(other_rash == "0", 0,
wordcount(subinstr(other_rash,";"," ",.)))

Nick
n.j.cox@durham.ac.uk

Lachenbruch, Peter

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.

*
*   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/
```

• References:

© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index