Re: st: tabstat if, by() stat(sum) Query

[Muhammad Anees <anees@aneconomist.com>]

Thanks Jung,

Yes I did obtain the same results using different options and
name-groupings. It was indeed the group-members-counts mistakes which
I had to adjust manually in Excel then to use with Stata.

Anees

On Sat, Nov 24, 2012 at 11:54 PM, Bert Jung <bjung59@gmail.com> wrote:
> Muhammad,
>
> I am not sure if I fully understand your problem but here some thoughts.
>
> (a) If you only want summary statistics "by(ctry2)" then the numbers
> in Excel and Stata should match.  The variable "ctry1" seems
> irrelevant for this calculation.
>
> (b) If you are comparing summary statistics for different groupings
> (one by ctry1 and the other by ctry2) then the composition of each
> group is likely to be quite different, and you would get different
> numbers for each calculation no matter what software you use.
>
> Maybe also double-check if you have any missing values and how those
> are treated by each software.  Maybe Stata omits the missing values in
> its calculation but Excel might include them - which would affect your
> statistics.  You can check observations count, which should be
> identical in both softwares.  In Stata:
>
> tabstat total primary secondary tertiary if year==1990, by(ctry2) stat(count)
>
> Best Bert
>
>
>
>
> On Thu, Nov 22, 2012 at 2:08 AM, Muhammad Anees <anees@aneconomist.com> wrote:
>> Muhammad
> *
> *   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/



-- 

Best
---------------------------
Muhammad Anees
Assistant Professor/Programme Coordinator
COMSATS Institute of Information Technology
Attock 43600, Pakistan
http://www.aneconomist.com
*
*   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/