Dear All, I was asked this question here (https://bbs.pinggu.org/forum.php?mod...a=#pid74912031). The data set is
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input long idstd float(lat lon) str13 longname
518601  -1.95972 30.12857 "56"           
518601  -1.95972 30.12857 "RN3"          
518601  -1.95972 30.12857 "Nyarugunga"   
518602 -1.936392 30.09101 "23"           
518602 -1.936392 30.09101 "KG 594 Street"
518602 -1.936392 30.09101 "Kacyiru"      
end
The desired output is that, for each "idstd", all the information is restructured in the same row (with elements in "type" as the variable names), i.e.,
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input long idstd float(lat lon) str13(street_number route political)
518601  -1.95972 30.12857 "56" "RN3"           "Nyarugunga"
518602 -1.936392 30.09101 "23" "KG 594 Street" "Kacyiru"   
end
Any suggestions are highly appreciated.