Table Design

[Anjaney Singh]

Hello Everyone! I am dealing with a dataset that includes Company_Name, Region, and Store_Number. I wanted to create a table that looks something like this:

Company_Name	Region	Store_Number
Company A	East	2
Company A	West	3
Company B	East	1
Company B	West	3
Company B	North	4

Could someone please help me out with the code for the same as well as a good way to export to excel as it is a large dataset and I am facing issues with the same?

Looking forward to a response to the same. Thanks again for the help!

[Carlo Lazzaro]

Anjaney:
welcome to this forum.
Have you already taken a look at the wonderful capabilities of the new -table- commands in Stata 17?

[Anjaney Singh]

Hi Carlo! Yes I did try using the tables command but am not able to figure it out. I need only distinct values for the store_number and not frequency. that is proving to be a problem.

[Nick Cox]

It's still a little unclear to me what you want but check out groups from the Stata Journal, which may help.

https://www.statalist.org/forums/for...updated-on-ssc