How to match a set of several observations from a given variable to each single observation of another variable?

[AM PHS]

Hi,

I have a dataset with several technological categories (around 100 categories). In another dataset I have a variable that identifies different regions (around 200 regions).

What I wanted it was to create a single dataset, where to each one of the regions it would be allocated each one of the technological categories.

In a Nutshell, my idea is to create a new dataset, with 100*200 observations, such that to each of the 200 regions it would be attributed all technological categories.

Does anyone have any idea how to proceed in oder to do so?

Thanks a lot!

[Nick Cox]

This may be what you are looking for:

 
help joinby

Please note http://www.statalist.org/forums/help#realnames

6. Why are real names preferred?

You are asked to post on Statalist using your full real name, including given name(s) and a family name, such as "Ronald Fisher" or "Gertrude M. Cox". Giving full names is one of the ways in which we show respect for others and is a long tradition on Statalist. It is also much easier to get to know people when real names are used.
If you overlook this on first registration, it is easy to fix. Click on “Contact us” located at the bottom right-hand corner of every page.