Re: st: SAS like command?

[James Muller <james.muller@internode.on.net>]

Here's a rough procedure:

Start with your dataset. Choose the variables you want to keep, suppose 
these are variables a, b and c
. bysort a b c: egen tabulation = sum(1)
. duplicates drop
Then you should have the below table as your new dataset.

Here's a simple example program that will simply output the data. If 
you're going to use this frequently, save it as tabNway.ado and put it 
in your adopath.

program define tabNway
   preserve
   keep `*'
   sort`*'
   by `*': egen tabcount = sum(1)
   duplicates drop
   list
   restore
end

In your case you would use input 'tabNway a b c'. I didn't use a tempvar 
because that gives a meaningless heading in the list. To get your other 
heading you can edit the program.

Cheers

James



Ricardo Ovaldia wrote:


> Dear all,
>
> SAS's proc mean with the class command expands the
> class variables creating all possible combinations
> including data with missing data.  Is there a way to
> do this in Stata?
>
> Thank you,
> Ricardo.
>
> Example:
>
> Starting with these data:
>
> Obs    a    b    c     n
>
> 1     0    0    0     3
> 2     0    0    1     4
> 3     0    1    1     5
> 4     1    1    1    10
> 5     0    1    0     7
> 6     0    1    1     5
> 7     1    0    0     8
> 8     1    0    1     9
>
> The SAS command:
>
> proc means;
> class a b c;
> var n;
> output sum=tsum  ;
>
> Yields:
>
>
> Obs    a    b    c    _TYPE_    _FREQ_    tsum
>  1    .    .    .       0         8       51
>  2    .    .    0       1         3       18
>  3    .    .    1       1         5       33
>  4    .    0    .       2         4       24
>  5    .    1    .       2         4       27
>  6    .    0    0       3         2       11
>  7    .    0    1       3         2       13
>  8    .    1    0       3         1        7
>  9    .    1    1       3         3       20
> 10    0    .    .       4         5       24
> 11    1    .    .       4         3       27
> 12    0    .    0       5         2       10
> 13    0    .    1       5         3       14
> 14    1    .    0       5         1        8
> 15    1    .    1       5         2       19
> 16    0    0    .       6         2        7
> 17    0    1    .       6         3       17
> 18    1    0    .       6         2       17
> 19    1    1    .       6         1       10
> 20    0    0    0       7         1        3
> 21    0    0    1       7         1        4
> 22    0    1    0       7         1        7
> 23    0    1    1       7         2       10
> 24    1    0    0       7         1        8
> 25    1    0    1       7         1        9
> 26    1    1    1       7         1       10
>
>
> Ricardo Ovaldia, MS
> Statistician 
> Oklahoma City, OK
>
>
> 		
> ____________________________________________________
> Start your day with Yahoo! - make it your home page 
> http://www.yahoo.com/r/hs 
> *
> *   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/
>
>  
*
*   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/