Re: st: an ordinary two-way table

["Michael Blasnik" <michael.blasnik@verizon.net>]

...
The program apparently wrapped in the emailing at this section:

> > syntax varlist( min=1 max=2) [if] [in], values(numlist)
> > [MISSing] * if "`missing'"!="" {  local novarlist "novarlist"
> > }

This should be two lines

line 1:
syntax varlist( min=1 max=2) [if] [in], values(numlist)  [MISSing] *

line 2:
if "`missing'"!="" {  local novarlist "novarlist"}


The second line should really be split up given more recent Stata conventions, 
as:

if "`missing'"!="" {
local novarlist "novarlist"
}


Michael

----- Original Message ----- 
From: "Giovanni Vecchi" <giovanni.vecchi@uniroma2.it>
To: <statalist@hsphsun2.harvard.edu>
Sent: Saturday, May 12, 2007 4:47 AM
Subject: RE: st: an ordinary two-way table



> Michael,
>
> thank you for sharing your program, and thanks to all statalisters who
> contributed to the discussion.
>
> Unfortunately, I have not managed to use *tabvals* successfully.
>
> By typing:
>
> sysuse auto, clear
> replace rep78=. if rep78==1
> tabvals rep78, values(1 2 3 4 5)
>
> I get:
>
> . tabvals rep78, values(1 2 3 4 5)
> option if required
> r(198);
>
> The syntax command in your code is likely to contain the information
> on how to use the "if" option... but I must be missing somenthing:
> *tabvals* refuses to cooperate with me... I would appreciate any help.
>
> - Giovanni
>
>
> > -----Original Message-----
> > From: owner-statalist@hsphsun2.harvard.edu
> > [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of
> > Michael Blasnik
> > Sent: Friday, May 11, 2007 5:10 PM
> > To: statalist@hsphsun2.harvard.edu
> > Subject: Re: st: an ordinary two-way table
> >
> > I just recalled that I had written a program with the same
> > goal a while back and it will do what you ask:
> >
> > program define tabvals
> > version 8.0
> > *!  v 1.0 M Blasnik
> > syntax varlist( min=1 max=2) [if] [in], values(numlist)
> > [MISSing] * if "`missing'"!="" {  local novarlist "novarlist"
> > }
> > marksample touse , `novarlist'
> > loca l var: word 1 of `varlist'
> >  qui levels `var' if `touse', local(hasvals) `missing'
> >  local addvals: list values - hasvals
> >  local tempobs: word count `addvals'
> >  if `tempobs'>0 {
> >   preserve
> >   local origN=_N
> >   qui expand `tempobs'+1 in l
> >   tempvar real
> >   qui gen byte `real'=(_n<=`origN')
> >   qui replace `touse'=1 in -`tempobs'/l
> >   forvalues i=1/`tempobs' {
> >    local obsn=`origN'+`i'
> >    local val: word `i' of `addvals'
> >    qui replace `var'=`val' in `obsn'
> >   }
> >
> >  noi tab `varlist' if `touse', subpop(`real') `missing' `options'
> >  restore
> >  }
> > else {
> >  noi tab `varlist' if `touse' , `missing' `options'
> > }
> > end
> >
> > Hopefully there aren't any word wrap problems or you may need
> > to fix this code up.  It lets you specify a values numlist
> > that applies to the first variable in the tabulate command.
> > It allows you to specify a second variable but does not
> > create new values for that one.  Since it relies on Stata's
> > tabulate command, it provides all of the options allowed with
> > tabulate.
> >
> > Michael Blasnik
*
*   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/