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]
Re: st: Combining and repeating value from another dataset
From
Michael LeGower <[email protected]>
To
[email protected]
Subject
Re: st: Combining and repeating value from another dataset
Date
Mon, 15 Apr 2013 08:54:26 -0400
And it seems like if you wanted to do that dynamically (i.e. you have a
bunch of these dataset pairs and you don't want to have to manually
retrieve all of the values of e for each Y dataset), you could do
something like the following:
use Y.dta
scalar e_value = e[1]
use X.dta, clear
gen e = e_value
On 4/15/2013 2:33 AM, statalist-digest wrote:
------------------------------
Date: Sun, 14 Apr 2013 11:38:43 +0100
From: Nick Cox<[email protected]>
Subject: Re: st: Combining and repeating value from another dataset
You don't need anything fancy.
Suppose the one value in Y.dta is 42.
In X data, you just go
gen e = 42
That's it. (If the value is a string value, say "Stata is easy", it's
the same story.)
That said, why do this? What analyses need it?
Nick
[email protected]
On 14 April 2013 06:19, Rahber Thariani<[email protected]> wrote:
>A question to which I am sure there is a simple answer, but as a novice in
>Stata, one I am having a hard time finding.
>
>I have a dataset with variables a, b, c and d (stored in X.dta). There are
>about 5000 observations.
>
>In another dataset I have only variable e(stored in Y.dta). There is only
>one observation.
>
>I want to create a composite dataset with variables a, b, c, d and e. I
>wish to repeat the same value of e 5,000 times in my new dataset for each of
>the existing 5,000 observations of a, b, c, and d.
>
>What do you suggest to create this structure?
*
* 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/