Hi,

I have the attached dataset which I have imported from Excel into Stata.

I haven't made any changes to the data so far.

I need to find a way to create a new variable that uniquely identifies combinations of stores and products. Eg two stores with 2 products each would result in 4 combinations in total and then see how many total combinations there are.

Note
- Store is the variable "store_id" and Product is the variable "type"

Please are you able to assist? I have a feeling it has to do with group or egen but doesn't seem to work unless I`m trying the wrong commands?

Thank you!