Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | Nick Cox <njcoxstata@gmail.com> |
| To | statalist@hsphsun2.harvard.edu |
| Subject | Re: st: writing a loop |
| Date | Thu, 20 Sep 2012 18:57:52 +0100 |
On Thu, Sep 20, 2012 at 6:41 PM, Amir Kasaeian <amir_kasaeian@yahoo.com> wrote:
> I wrote a loop for reading stata files and then export them in csv format.
> Now, I want to export them in xls or xlsx formats, but I don't know how.
> How can I do this?
> my codes are as follows:
> How should I change it to do my work?
>
> forvalues i= 0/29{
> use "C:\Step\Total88\Step`i'.dta", clear
> outsheet using "C:\Step\Total88\Step`i'.csv", comma replace
> }
*
* 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/