Carlo Lazzaro <[email protected]>
Not sure I've understood, but if so, here is one method of calculation.
use bp* tcresult using http://www.stata-press.com/data/r9/nhanes2, clear
ren bpsystol a
ren bpdiast b
ren tcresult c
g double d=.
qui forv i=1/`=_N' {
if a[`i']<. {
g double tmp=a[`i']*b-c
su tmp, meanonly
replace d=r(mean) in `i'
drop tmp
}
}
On Tue, Oct 14, 2008 at 4:50 AM, Carlo Lazzaro
<[email protected]> wrote:
> Dear Statalisters,
> I have three variables (a; b; C with 10,000 observations each) in long
> format.
> For each value of a I would like to obtain the following one:
>
> (a1 * b1) - c1
> .
> .
> .
> .
> (a1*b10,000)-c10,000;
>
> Repeat the above reported would-be 10,000 times (i.e., from a1 to a10,000)
>
> Create a new variable d in which the mean of each one of the 10,000
> iterations are stored and can be displayed.
>
> I suppose there's way of doing this with Stata 9.2/SE, but I cannot figure
> out the proper syntax.
*
* 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/
