I have a number of variables which I would like to convert into observations. The data is structured like follows. I would like to have 4 variables; id (containing city name) and then ng, ps and sq (the values).

I have tried using

reshape long ng, i(dist)

variable _j contains all missing values

I also have all cities in a variable list.


Array

desired output:
city ng ps sq
wien ### ### ###
graz ### ### ###
linz ### ### ###