I have been reading the Statalist for years and I am thrilled to finally join this forum and potentially interact with Nick Cox and other Stata legends who seem to know all the answers.

I have the following data set that specifies one SGP value for a given range of values (Low Limit to High Limit)
SGP Low Limit Gain High Limit Gain
3 0 5
4 6 8
6 9 10
From the data set above, I need to create a long dataset that looks like this:
SGP Gain
3 0
3 1
3 2
3 3
3 4
3 5
4 6
4 7
4 8
6 9
6 10
Does anyone know how to do it?

Thanks!