Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: Number of observations in a matrix -codebook- -makematrix-


From   "Herve STOLOWY" <stolowy@hec.fr>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: Number of observations in a matrix -codebook- -makematrix-
Date   Wed, 09 Apr 2008 19:52:56 +0200

Dear Statalisters:

I have a sample with 403 companies and 822 observations (several years per company). I would like to report the 403 figure in a matrix (to export it later in  a table). 

With the following command,
codebook name if country=="GBR" & post_ifrs==1 & ib_scaled!=. & ib_scaled2!=. & sample_sum==1
I get the correct figure for unique values (403). However, I don't find this figure in the return list.

With -tabulate- and the following command:
tabulate name if country=="GBR" & post_ifrs==1 & ib_scaled!=. & ib_scaled2!=. & sample_sum==1

I get the correct figure in the return list: r(r)

I then tried the following command with -makematrix- (downloadable from ssc): 

makematrix c1, from(r(r)) label listwise: tabulate name if country=="GBR" & post_ifrs==0 & ib_scaled!=. & ib_scaled2!=. & sample_sum==1

I get an error message: too many values.

Would you have an idea about how to get the 403 figure in a matrix?

Best regards

Herve Stolowy

***********************************************************
Professeur/Professor
President of the French Accounting Association (AFC)
HEC Paris
Departement Comptabilite Controle de gestion / Dept of Accounting and Management Control
1, rue de la Liberation
78351 - Jouy-en-Josas
France
Tel: +33 1 39 67 94 42 - Fax: +33 1 39 67 70 86
mail: stolowy at hec dot fr
web: http://www.hec.fr/stolowy

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index