RE: st: Table output from three variables

[Haluk Vahaboglu <vahabo@hotmail.com>]

Nick Sergiy,
Thank you both for immediate reply.
Sergiy I intent "Table output".
Nick thanks after dropping missing observations [iw] worked nicely.

Haluk Vahaboğlu




----------------------------------------
> Date: Fri, 26 Jul 2013 23:59:27 +0100
> Subject: Re: st: Table output from three variables
> From: njcoxstata@gmail.com
> To: statalist@hsphsun2.harvard.edu
>
> In the thread you quote the use of [aw] was arbitrary. Did you try
> [fw] or [iw]?
>
> Nick
> njcoxstata@gmail.com
>
> On 26 July 2013 23:35, Haluk Vahaboglu <vahabo@hotmail.com> wrote:
>
>> I am using Stata 12.1 for Linux 64 bit.
>> I want to get a table from three variables, using one as row other as column and the third as the element of the matrix (table).
>> Data is something like:
>> Compound Year Amount
>> X 2009 5
>> X 2010 9
>> X 2011 2
>> Y 2009 3
>> Y 2011 8
>> want to get a table as:
>> . 2009 2010 2011
>> X 5 9 2
>> Y 3 . 8
>>
>> This might be achieved via the "reshape wide.." command but could this be also possible without reshaping the data?
>> I cannot find an exact answer to my problem in help files, manuals, FAQ (there is one without an exact solution to my problem) and google search.
>> To a similar thread by AJ Medwick (http://www.stata.com/statalist/archive/2009-05/msg00337.html) Nick J Cox posted a solution"tab var1 var2 [aw=var3], matcell(matrix)" that gives an output which is not what I want.
> *
> * 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/