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

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

From |
Maarten Buis <maartenlbuis@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: Problem in appending data files. |

Date |
Tue, 6 Nov 2012 15:09:04 +0100 |

replace province=`i' should be replace province=`i' if province == . -- Maarten On Tue, Nov 6, 2012 at 3:07 PM, Maarten Buis <maartenlbuis@gmail.com> wrote: > use "C:\Total85\S0.dta" > gen province = 0 > forvalues i= 1/29 { > append using "C:\Total85\S`i'.dta" , > replace province=`i' > } > save "C:\Total85\Total.dta", replace > > -- Maarten > > On Tue, Nov 6, 2012 at 2:46 PM, Amir Kasaeian <amir_kasaeian@yahoo.com> wrote: >> Dear all, >> Good day! >> I have a problem in appending my data files. >> I wrote a loop but there is little problem that I don't know how to resolve it. >> Your help will be appreciated. >> I use stata MP 11. >> The problem is that I have 30 files in a folder named S0 through S1. I want to have a final file named for example "Total" including a new variable as an indicator for observations of each of 30 separate files. >> I wrote my file as : >> >> forvalues i= 0/29 { >> append using "C:\Total85\S`i'.dta" , >> gen Province=`i' >> save "C:\Total85\Total.dta", replace >> } >> >> >> but the code stops at the first step alarming: >> >> >> . do "C:\Users\AK\AppData\Local\Temp\STD00000000.tmp" >> >> . forvalues i= 0/29 { >> 2. append using "C:\Total85\S`i'.dta" , >> 3. gen Province=`i' >> 4. save "C:\Total85\Total.dta", replace >> 5. } >> file C:\Total85\Total.dta saved >> Province already defined >> r(110); >> >> end of do-file >> >> r(110); >> >> >> The Total file just includes observation from the S0. >> Would you please help me to modify my codes? >> Bunch of thanks, >> Amir >> >> * >> * For searches and help try: >> * http://www.stata.com/help.cgi?search >> * http://www.stata.com/support/faqs/resources/statalist-faq/ >> * http://www.ats.ucla.edu/stat/stata/ > > > > -- > --------------------------------- > Maarten L. Buis > WZB > Reichpietschufer 50 > 10785 Berlin > Germany > > http://www.maartenbuis.nl > --------------------------------- -- --------------------------------- Maarten L. Buis WZB Reichpietschufer 50 10785 Berlin Germany http://www.maartenbuis.nl --------------------------------- * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/

**Follow-Ups**:**Re: st: Problem in appending data files : an error happened***From:*Amir Kasaeian <amir_kasaeian@yahoo.com>

**Re: st: Problem in appending data files.***From:*Amir Kasaeian <amir_kasaeian@yahoo.com>

**References**:**st: Problem in appending data files.***From:*Amir Kasaeian <amir_kasaeian@yahoo.com>

**Re: st: Problem in appending data files.***From:*Maarten Buis <maartenlbuis@gmail.com>

- Prev by Date:
**Re: st: Problem in appending data files.** - Next by Date:
**st: RE: Problem in appending data files.** - Previous by thread:
**Re: st: Problem in appending data files.** - Next by thread:
**Re: st: Problem in appending data files.** - Index(es):