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 |
"David Radwin" <dradwin@mprinc.com> |

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

Subject |
RE: st: Mergining horozontally excel files under a particular patern |

Date |
Tue, 3 Jul 2012 15:11:12 -0700 (PDT) |

I think you lost a comma and broke the line right before "sheet." -sheet- is an option of the -import excel- command. The fourth and fifth lines should be one line like this: . insheet using "wer.csv", sheet("Sheet`i'") firstrow clear David -- David Radwin Senior Research Associate MPR Associates, Inc. 2150 Shattuck Ave., Suite 800 Berkeley, CA 94704 Phone: 510-849-4942 Fax: 510-849-0794 www.mprinc.com > -----Original Message----- > From: owner-statalist@hsphsun2.harvard.edu [mailto:owner- > statalist@hsphsun2.harvard.edu] On Behalf Of sabbas gidarokostas > Sent: Tuesday, July 03, 2012 2:04 PM > To: statalist@hsphsun2.harvard.edu > Subject: Re: st: Mergining horozontally excel files under a particular > patern > > Hi scott > > > I tried what you said > > clear > > > tempfile tmp > local j = 1 > forv i = 39(-1)1 { > insheet using "wer.csv" > sheet("Sheet`i'") firstrow clear > if mod(`i',3) !=0 { > qui merge 1:1 _n using `tmp', nogenerate > save `tmp' ,replace > } > else { > save `tmp', replace > } > if mod(`j', 3) == 0 { > save gr`i', replace > local j = 1 > } > else { > local j = `j' + 1 > } > } > > > but I get the mistake > > unrecognized command: sheet > > thanks > > On 7/3/12, sabbas gidarokostas <sabbasgidarokostas@googlemail.com> wrote: > > thanks scott. I will try this. Many thanks > > > > On 7/3/12, Scott Merryman <scott.merryman@gmail.com> wrote: > >> Something like: > >> > >> clear > >> tempfile tmp > >> local j = 1 > >> forv i = 39(-1)1 { > >> import excel "C:\Users\scott.merryman\Desktop\Book1.xlsx", > >> sheet("Sheet`i'") firstrow clear > >> if mod(`i',3) !=0 { > >> qui merge 1:1 _n using `tmp', nogenerate > >> save `tmp' ,replace > >> } > >> else { > >> save `tmp', replace > >> } > >> if mod(`j', 3) == 0 { > >> save gr`i', replace > >> local j = 1 > >> } > >> else { > >> local j = `j' + 1 > >> } > >> } > >> > >> > >> > >> Scott > >> > >> On Mon, Jul 2, 2012 at 12:31 PM, sabbas gidarokostas > >> <sabbasgidarokostas@googlemail.com> wrote: > >>> I have an excel file that contains 39 sheets > >>> 1,2,3,4,5,6,7,8,9,10,11,.. > >>> > >>> I want tfirst o merge sheet 3 with 2 and then merge the new sheet that > >>> results from this merging with sheet 1. So 3+2+1 > >>> Similarly, I want to merge first sheet 6 with 5 and then merge the new > >>> sheet that results from this merging with sheet 4. So. 6+5+4 > >>> Similarly, I want to merge first sheet 9 with 8 and then merge the > >>> new sheet that results from this merging with sheet 7. So, 9+8+7 > >>> And so forth > >>> To be more specific, > >>> My goal is to merge horizontally all the data contained in sheet 3 > >>> with the data contained in the matrix [C5 up to the C-end and C5 up to > >>> End-5] of Sheet 2. The outcome of this merging is then merged > >>> horizontally with the data contained in the matrix [C5 up to the C-end > >>> and C5 up to End-5] of Sheet 1 > >>> > >>> Similarly, I want to merge horizontally all the data contained in > >>> sheet 6 with the data contained in the matrix [C5 up to the C-end and > >>> C5 up to End-5] of Sheet 5. The outcome of this merging is then merged > >>> horizontally with the data contained in the matrix [C5 up to the C-end > >>> and C5 up to End-5] of Sheet 4 > >>> > >>> and so forth. > >>> > >>> Is there any way to do this particular merging > >>> > >>> thanks * * 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**:**Re: st: Mergining horozontally excel files under a particular patern***From:*sabbas gidarokostas <sabbasgidarokostas@googlemail.com>

**References**:**st: Mergining horozontally excel files under a particular patern***From:*sabbas gidarokostas <sabbasgidarokostas@googlemail.com>

**Re: st: Mergining horozontally excel files under a particular patern***From:*Scott Merryman <scott.merryman@gmail.com>

**Re: st: Mergining horozontally excel files under a particular patern***From:*sabbas gidarokostas <sabbasgidarokostas@googlemail.com>

**Re: st: Mergining horozontally excel files under a particular patern***From:*sabbas gidarokostas <sabbasgidarokostas@googlemail.com>

- Prev by Date:
**Re: st: negative variance after gb2fit** - Next by Date:
**Re: st: xttobit & stata 12: Initial values not feasible** - Previous by thread:
**Re: st: Mergining horozontally excel files under a particular patern** - Next by thread:
**Re: st: Mergining horozontally excel files under a particular patern** - Index(es):