Nick,
Actually, what I am looking for is how to identify all the past weekending
data sets from a particular reference date.
I have an ado file like the following:
prog def rptflex
version 7
set more 1
pause on
qui{
args mmddyy
insheet using Q:\DS5\BILL.WE`mmddyy'.csv, comma clear
tempfile tmp; save `tmp', replace;
<snip>
}
If I type rptflex 041004, I use weekending 041004 data set and then would
like to bring all the data sets for past 9 months, which are by weekending
dates. My question is how to create a series of weekending dates (always
Saturday) from the current date, in this case, it is 041004 (April 10,
2004). I would like to bring the preceding weekending data sets which are
for weekending 040304 (BILL.WE040304) and then 032704 (BILL.WE032704) and so
on till end of 9 months and compare with the current data (merge and
subsequently, append the changes).
Hope this clarifies my question. Is something like this attainable in STATA?
Thank you for your kind help.
Sincerely,
Pinaki Mitra
-----Original Message-----
From: Nick Cox [mailto:[email protected]]
Sent: Wednesday, April 14, 2004 6:14 PM
To: [email protected]
Subject: st: RE: How to generate preceding dates from a particular date
If I understand this correctly, you have
one dataset in memory, say
. use data041004
and observations are for people (say),
with some identifier variable. If an
identifier, say
"William W. Gould, President"
exists in that dataset, you want to know
if there are observations in other datasets
with the same identifier.
If this is the right description, you can do very
little unless you combine these datasets into one,
presumably with -append-. Stata can tell you
some basic things about datasets not in memory,
such as what variables they contain, but it
will say nothing about individual observations.
No local macro will help on this.
Nick
[email protected]
MITRA PINAKI
> I have data by weekending dates where weekending is always
> Saturday. For
> example, data sets go by data041004, data040304, data032704,
> etc. When I use
> any particular data set, I would like to check with past 9
> months of weekly
> data and see if any of the current records exists in previous
> data sets. I
> would like to get any help on how to create the series of proceeding
> weekending dates. I tried to create a local variable with the current
> weekending date but couldn't convert it to date format and
> subsequently, any
> preceding dates.
*
* 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/
