Notice: On March 31, it was **announced** that Statalist is moving from an email list to a **forum**. The old list will shut down at the end of May, and its replacement, **statalist.org** is already up and running.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

From |
"Hardy, Dale S" <Dale.S.Hardy@uth.tmc.edu> |

To |
"statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu> |

Subject |
st: syntax help |

Date |
Wed, 16 Nov 2011 20:12:47 -0600 |

Dear Stata Users, I am kindly asking for your help. I am defining a macro. In this macro I would like to calculate a variable called glycemic load for each subject-1540 subjects. The formula is: total gload=Sum[GI of food * Carbohydrate (gms) of food * frequency of food eaten ] I have 43 variables for each specific food (GI, Carbohydrate, frequency). Each food has its corresponding GI, Carbohydrate, and frequency. I want to calculate the gload of each food and sum the gloads of all foods to make a summary gload value for each subject. Below is my syntax and the feedback I got from stata when I -set trace on- SYNTAX local numsubjects=_N //record number .forvalues i=1(1)`numsubjects'{ forvalues i=1(1)1541 { local sum=0 forvalues sum=1(1)43 { local j="gi1-gi43 cho1-cho43 freq1-freq43" forvalues j=1(1)43 { foreach var of varlist gi1-gi43 { foreach x of varlist cho1-cho43 { foreach f of varlist freq1-freq43 { . local sum= (`var'`j'[`i'] * `x'`j'[`i'] * `f'`j'[`i']) + `sum' } } } } replace gload=`sum' in `i' } } } SET TRACE ON - forvalues i=1(1)`numsubjects'{ = forvalues i=1(1)1541{ - forvalues i=1(1)1541 { - local sum=0 - forvalues sum=1(1)43 { - local j="gi1-gi43 cho1-cho43 freq1-freq43" - forvalues j=1(1)43 { - foreach var of varlist gi1-gi43 { - foreach x of varlist cho1-cho43 { - foreach f of varlist freq1-freq43 { - local sum= (`var'`j'[`i'] * `x'`j'[`i'] * `f'`j'[`i']) + `sum' = local sum= (gi11[1] * cho11[1] * freq11[1]) + 1 - } - local sum= (`var'`j'[`i'] * `x'`j'[`i'] * `f'`j'[`i']) + `sum' = local sum= (gi11[1] * cho11[1] * freq21[1]) + 1 - } - local sum= (`var'`j'[`i'] * `x'`j'[`i'] * `f'`j'[`i']) + `sum' = local sum= (gi11[1] * cho11[1] * freq31[1]) + 1 - } - local sum= (`var'`j'[`i'] * `x'`j'[`i'] * `f'`j'[`i']) + `sum' = local sum= (gi11[1] * cho11[1] * freq41[1]) + 1 - } - local sum= (`var'`j'[`i'] * `x'`j'[`i'] * `f'`j'[`i']) + `sum' = local sum= (gi11[1] * cho11[1] * freq51[1]) + 1 freq51 not found } } } } replace gload=`sum' in `i' } } } r(111); end of do-file r(111); I appreciate all the help you can give me. Dale * * 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/

**Follow-Ups**:**st: Re: syntax help***From:*"Joseph Coveney" <jcoveney@bigplanet.com>

- Prev by Date:
**Re: st: quick question : survival curves with pweighted data in Stata 12** - Next by Date:
**st: Re: syntax help** - Previous by thread:
**st: quick question : survival curves with pweighted data in Stata 12** - Next by thread:
**st: Re: syntax help** - Index(es):