Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.


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

st: RE: RE: creating 2 datasets in memory without saving and merge


From   Nick Cox <[email protected]>
To   "'[email protected]'" <[email protected]>
Subject   st: RE: RE: creating 2 datasets in memory without saving and merge
Date   Fri, 27 Apr 2012 18:29:57 +0100

In addition: 

You can -merge- the data in memory with another dataset without a -save- of the current dataset. It is often prudent to -save- that current dataset, however. The main reason is that your -merge- may mess up the dataset because it was a bad idea in some sense. In that circumstance you end up with a messed-up dataset and may have to re-create the dataset before the -merge-. Same goes for -append-, etc. 

Nick 
[email protected] 


-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Nick Cox
Sent: 27 April 2012 18:15
To: '[email protected]'
Subject: st: RE: creating 2 datasets in memory without saving and merge

1. You can hold precisely one (1) dataset in memory in Stata at once. This is circular in so far as what you hold in memory is always regarded as one (1) dataset, regardless of whether that dataset was originally two or more datasets in some sense, Stata or not Stata. Nevertheless the circularity is not vicious. 

2. There are various ways of combining two or more datasets, including the use of -merge- or -append- and just typing or pasting in new data into the Editor. 

3. Whether a dataset has been -save-d is a different question. No rule says that you must -save- data. It would be a waste of effort to combine datasets and not -save- the results if you intend to -use- that dataset later, but that's a practicality, not a rule. 

4. Why you say that whatever you have in mind is "not good" is completely unclear to me. 

Nick 
[email protected] 

tashi lama

       I will be using 2 diff databases to get my data in stata. And I need to merge those two data to use for my analysis. One obvious way is to get the data from  database 1 and save it with .dta file. Then use another database to pull data in stata memory(this is doable since my memory is clear) and use merge command. Unfortunately, this method is not good since i will have to save one dataset. Is there anyway I could pull two datasets in the memory without saving anyof the datasets? Or, what are my choices to get my intended result. Please let me know if my question is not clear. 

*
*   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/


© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index