Dear All,
I have three columns in stata, the db column, dgdpmillionpkr and the districts. The dgdpmillionpkr has 110 observation. The db has two id values, db = 1 for the first 110 observations of dgdpmillionpkr and db=2 for the replicated 110 observations appended below the first 110 observation. I want to declare first 110 of districts as string and for the remaining 110 dgdpmillionpkr value of the respective districts, How I can code/do this in stata? Actually I want to show labels(districts name) and its values in order to visualize my dgdpmillionpkr data in map. I am stucked here, any help will be greatly appreciated. Thanks
Wajid Ali
To declare the first 110 districts as string and the remaining 110 districts as dgdpmillionpkr values of the respective districts, you can use the following Stata code:
/* Declare first 110 districts as string */
forvalues i = 1/110 {
tostring districts[`i'], replace
}
/* Set value labels for districts */
label define districts_labels 1 "District1" 2 "District2" /* and so on for all districts */
label values districts districts_labels
/* Set value labels for dgdpmillionpkr */
label variable dgdpmillionpkr "GDP (in millions of PKR)"
This code will first convert the first 110 districts to string variables using the tostring command. Then, it will set value labels for the districts using the label define and label values commands. Finally, it will set a label for the dgdpmillionpkr variable using the label variable command.
Note that you will need to replace "District1", "District2", etc. with the actual names of your districts.
I hope that will help . please recommend my reply if you find it useful.Thanks
- Badges
- Science topic
- Similar topics
- Analytical Chemistry
- Column