Hello, guys! I need help on a data management problem.
The data looks like follows:
firm dept product
1 a a, b
1 b c, r
1 c d, a
2 d d, f
2 e I, y
2 f g
Firm 1 & 2 each has some departments. Each department has some products. I
want to a variable which lists all the products a firm has (a, b, c, d, r
for firm 1) and for firm 2 (d, f, I, y, g). Any help would be appreciated.
Willie
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/