Bookmark and Share

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]

RE: st: Count observations


From   "Miguel Angel Duran Munoz" <[email protected]>
To   [email protected]
Subject   RE: st: Count observations
Date   Tue, 23 Jul 2013 18:06:38 +0200

Thank you very much for your help. Let me explain a bit more why -count-
did not work. There is something in my variables that I did not make
explicit in my first message (I thought could solve it on my own after
being helped, but it is not the case).

As I told you, the variable fee describes the type of fee (eg, A B C).
Nevertheless, the dataset is constructed in a way that A and B, for
instance, are the same (specifically, I have "commitment fee" and
"commitment regular fee", but both types are the same). But, although A
and B are the same, they both might be included for the same firm.

Therefore, given this illustrative dataset,

Id    Type-of-fee

1          A
1          B
1          C
2          C
2          A
3          A
4          B
4          .
4          A

there are 4 firms that have either A or B. I was trying to use this,
-bysort id: count if fee=="A" | fee=="B", but what I get is (obsviously)
split by firms.

I am sorry for the initial confusion.

Miguel.

 Unclear why it does not work. It works with the following:
>
> ******* start example
> clear all
> input id
> 1
> 1
> 1
> 2
> 2
> 3
> 4
> 4
> 4
> end
> input str2 fee
> A
> B
> C
> C
> A
> A
> B
> ""
> A
> count if fee=="A"
> ******* end example
>
> Notice that another alternative is -tab fee-
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Miguel Angel
> Duran Munoz
> Sent: Tuesday, July 23, 2013 10:51 AM
> To: [email protected]
> Subject: Re: st: Count observations
>
> Hi, Statalisters. I have the following doubt. My dataset is arranged in
> the following way. I have a variable that identifies firms (say id).
> Another variable describes whether different types of fees (eg, A B C)
> applies to a firm. Accordingly, the dataset looks similar to
>
> Id    Type-of-fee
>
> 1          A
> 1          B
> 1          C
> 2          C
> 2          A
> 3          A
> 4          B
> 4          .
> 4          A
>
> I would like to know, for instance, the number of A fees that there are. I
> have used -count- but I am not able to get what I want. Will you please
> help me?
>
> Thanks in advance.
>
> Miguel.
>
>
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/faqs/resources/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/faqs/resources/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/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/


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