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/
