RE: st: date("01jan1960", "DMY") does not seem to work with -if- qualifier of the command -tablist-

[Amy Dunbar <Amy.Dunbar@business.uconn.edu>]

Why will A work, but not B?

A.  replace event1=1 if date == `=date("02Jan2003", "DMY")'
B.  replace event1=1 if date >= `=date("31Dec2002", "DMY")' & date <= `date("03Jan2003", "DMY")'
*replace event1=1 if date >= 15705 & date <=15708  // this runs

Amy Dunbar

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Eric Booth
Sent: Monday, March 21, 2011 9:07 PM
To: <statalist@hsphsun2.harvard.edu>
Subject: Re: st: date("01jan1960", "DMY") does not seem to work with -if- qualifier of the command -tablist-

<>

Try changing your last line to:  

 tablist bday name if statadate > `=date("01Jan1960", "DMY")'

- Eric
__
Eric A. Booth
Public Policy Research Institute
Texas A&M University
ebooth@ppri.tamu.edu


On Mar 21, 2011, at 7:22 PM, Jeremy Page wrote:

> I am a frequent user of the user generated command -tablist- and I 
> have run into a behavior that I can not explain.  I am trying to use 
> Stata's -date- command with the -if- qualifier to restrict 
> observations from displaying in -tablist-.  When I attempt to do this 
> there appears to be a problem.  I am able to use the -date- command to 
> restrict observations with -tabulate- and I am able to restrict 
> observations in -tablist- with a local variable being defined by the
> -date- command but not with -tablist-.  It is my understanding that 
> the -if- qualifiers across all programs should act the same.  Am I 
> missing something?  I have included an example below using a Stata 
> supplied data set.
> 
> I am using version 1.2 of -tablist- which can be found at -findit
> tablist- and my version of Stata is 10.1 on a Windows XP machine.
> 
> Thank you for your help.
> 
> Best,
> Jeremy
> 
> 
> 
> **********begin example*************** clear use 
> http://www.stata-press.com/data/r10/datexmpl.dta
> 
> 
> gen statadate = date(bday, "DMY")
> 
> format statadate %td
> 
> list statadate
> 
> display date("01Jan1960", "DMY")
> 
> ***it works with tabulate
> tab bday name if statadate > date("01Jan1960", "DMY")
> 
> 
> ***it works with a local variable
> local dte = date("01Jan1960", "DMY")
> tablist bday name if statadate > `dte'
> 
> ***it does not work with tablist
> tablist bday name if statadate > date("01Jan1960", "DMY")
> 
> 
> ************end example***************
> 
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/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/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/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/