Ed Bassin, Ph.D.
> I have an ado that uses the file command to convert a Stata
> dataset to an
> HTML table. To improve the performance of the program, I
> want to have it
> loop through the rows and execute a single command to write
> out each row.
> To do this, I first go through the varlist and build a
> macro that says how
> the rows should be written, e.g.,
> <TR><TD> %8.2f (var1[`i']) </TD><TD> %5s (var2[`i'])
> </TD></TR>
> The problem I am encountering involves building a macro
> that contains an
> untranslated macro. I have been able to get the program to work by
> replacing `i' above with RoWNuM and having a line that reads
> local writeme : subinstr local writestring "RoWNuM" "`i'"
> then have a
> file write x `writeme' _newline
> but that means an extra command has to get executed for
> each row of data,
> something that I'm sure compromises the efficiency of the
> code. Still, the
> subinstr method above is 1/3 faster than looping through
> the varlist for
> each row of data.
>
> Is there a way to have writestring contain `i'?
In Stata 8, the expansion operator -macval()-
may be what you need.
Nick
[email protected]
*
* 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/
