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: Creating pairs
From
Michael Betz <[email protected]>
To
"[email protected]" <[email protected]>
Subject
st: Creating pairs
Date
Mon, 2 Apr 2012 15:05:51 +0000
Hi all,
I have two variables "msa" and "ind" representing US metro areas and industries, respectively. I want to create a data set where each msa has an observation for each industry.
I have:
msa ind
1 001
2 003
3 005
4 007
5 009
And would like:
msa ind
1 001
1 003
1 005
1 007
1 009
2 001
2 003
2 005
ect.
I'm sure there's a simple solution, but I'm having trouble thinking of one.
Thanks,
Mike
*
* 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/