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 |
Eric Booth <eric.a.booth@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: use of tempfile |

Date |
Thu, 19 Apr 2012 11:10:06 -0500 |

<> On Apr 19, 2012, at 10:53 AM, Prakash Singh wrote: > > I could write the code but it gives me unnecessary data file which I > will not be using in analysis ( all other created data file baring > sales1_1_20.dta). One obvious answer is that I can delete them once I > have the final data file but then I thought there could some way using > that I can bypass save command and that is the reason I have put > tempfile as the subject of my query thread. Ok, since you don't need help with any of the other code, and you say that you just want to know how to use a -tempfile- to do a merge, here is a example that you can adapt to your dataset: ****************! sysuse auto, clear tempfile one two save `one', replace keep if rep78 > 3 save `two', replace use `one', clear merge 1:1 make using `two' ****************! See -help tempfile- for more help. - Eric __ Eric A. Booth Public Policy Research Institute Texas A&M University ebooth@ppri.tamu.edu +979.845.6754 On Apr 19, 2012, at 10:53 AM, Prakash Singh wrote: > Eric > In the "before" data set I have list of variable say "n", now out of > these n variables some variable are so kept in the data set that for > each state_code they represent sales, export value of certain > industry. My interest here to transform the data set in such a way > that these sales and export value for the particular industry as > separate variables. to put other way around I want to make my data > free from state_code. > > so if the name of the data file is sales1.dta (before) > > Then using keep if command and renaming the numbers in state_code and > other variable I have created data file assigning number identical to > the category of state_code. the state_code variable is having 20 > different values (category) and that's how I have sales1_1.dta to > sales1_20.dta after use of keep if command. Now I have to merge these > 20 newly created data set from "before" situation to get one final > data set let us call it sales1_1_20.dta "after" situation so that > sales, export of different industry will come beside each other as > separate variable in one data file. common_id is the variable being > able to uniquely identify the observation is sued to merge. > > I could write the code but it gives me unnecessary data file which I > will not be using in analysis ( all other created data file baring > sales1_1_20.dta). One obvious answer is that I can delete them once I > have the final data file but then I thought there could some way using > that I can bypass save command and that is the reason I have put > tempfile as the subject of my query thread. > > > Prakash > * > * 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/ * * 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/

**References**:**st: use of tempfile***From:*Prakash Singh <prakashbhu@gmail.com>

**Re: st: use of tempfile***From:*Nick Cox <njcoxstata@gmail.com>

**Re: st: use of tempfile***From:*Prakash Singh <prakashbhu@gmail.com>

**Re: st: use of tempfile***From:*Nick Cox <njcoxstata@gmail.com>

**Re: st: use of tempfile***From:*Prakash Singh <prakashbhu@gmail.com>

**Re: st: use of tempfile***From:*Nick Cox <njcoxstata@gmail.com>

**Re: st: use of tempfile***From:*Prakash Singh <prakashbhu@gmail.com>

**Re: st: use of tempfile***From:*Nick Cox <njcoxstata@gmail.com>

**Re: st: use of tempfile***From:*Prakash Singh <prakashbhu@gmail.com>

**Re: st: use of tempfile***From:*Eric Booth <eric.a.booth@gmail.com>

**Re: st: use of tempfile***From:*Prakash Singh <prakashbhu@gmail.com>

- Prev by Date:
**Re: st: use of tempfile** - Next by Date:
**st: Is it possible to use Nelder Mead optimization with ml** - Previous by thread:
**Re: st: use of tempfile** - Next by thread:
**RE: st: use of tempfile** - Index(es):