Bookmark and Share

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]

st: Creating pairs


From   Michael Betz <betz.40@buckeyemail.osu.edu>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index