Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: storing values from within "by varname :" command


From   "Michael Blasnik" <[email protected]>
To   <[email protected]>
Subject   Re: st: storing values from within "by varname :" command
Date   Sun, 22 Oct 2006 11:43:02 -0400

This type of code can be useful in some circumstances, but I think you should first look at -statsby- which basically does the same thing for almost any Stata command that returns results, only faster and in a single line.

Michael Blasnik

----- Original Message ----- From: "David Elliott" <[email protected]>
To: <[email protected]>
Sent: Sunday, October 22, 2006 10:19 AM
Subject: Re: st: storing values from within "by varname :" command



Andrey

Unless the command you are iterating for the by variables allows some
way to save values, or if you actually add that feature to the ado you
are calling, I don't believe what you want is possible within the
context of the by command.

There is an alternative, however:

===============================
// This assumes variables region and group are numeric
// If they are strings the commands postfile and post and the ifcmd must
// be altered accordingly

tempname h
postfile `h' region_level group_level count using mycounts, replace

levelsof region, local(l_region)
levelsof group, local(l_group)

foreach region_level of local l_region {
foreach group_level of local l_group {
count if region==`region_level' & group==`group_level'
// count is returned in r(N) so
local count=`r(N)'
post `h' (`region_level') (`group_level') (`count')
}
}

postclose `h'
use mycounts, clear
browse

=============================

With a little work, this could be adoed to accept a more general case
of passthru commands and capture the postfile output, even
transferring variable and value labels to the new file.
*
*   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/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index