Reshaping long to wide to export into excel for GIS

[Lorien Nair]

Hi Statalisters!

I am working with a individual panel dataset that I want to use to create severaal district level heat maps of sterilizations conducted at the district level that evolved over many years (I have given a -dataex- sample below). I hope to not create any confusion with my question.

So keeping in mind the data I have where v316 is the year of sterilization of individual i, sterilzn_intens is the number of sterilzn in a year at a district, I wanted to create a variable labelled for example district1982 that would give the number of sterilizations in different districts in the year 1982. SO figured I would get that using -reshape-

My code was

reshape wide dist_sterilzn, i(districtia) j(v316) // districtia - is a district id, v316 is year of sterilization of an individual and dist_sterilzn is the number of sterilizations in a given district in the year v316.

However I got the error that There are observations within i(districtia) with the same value of j(v316). Which is entirely possible since two different individuals in the same district could have had sterilizations in the same year. So instead should I simply create a for loop that would for eaxmple produce the following variables

districtia	newid	v316	dist_sterilzn	dist_1981	dist_1982	dist_1983
201	1	1981	40	40	32	63
201	1	1982	32	40	32	63
201	2	1981	40	40	32	63
201	3	1983	63	40	32	63
202	4	1981	82	82	27	42
202	4	1982	27	82	27	42
202	5	1983	42	82	27	42

* Example generated by -dataex-. To install: ssc install dataex
clear
input float newid int(v316 districtia) float(sterilization sterilzn_intens dist_sterilzn) long state int(yearoi yearofbirth) str30 district_labels str5 CNTRY_NAME str3 CNTRY_CODE str6 IPUM1993 str3 DIST1993 byte PARENT str17 state_str
 2495 1981 219 1 1 30 1 1992 1950 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2314 1984 219 1 1 25 1 1992 1953 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2522 1986 219 1 1 35 1 1992 1962 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2541 1981 219 1 1 30 1 1992 1955 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2316 1987 219 1 1 50 1 1992 1950 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2314 1984 219 1 1 25 1 1992 1953 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2544 1979 219 1 1 19 1 1992 1955 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2460 1987 219 1 1 50 1 1992 1962 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2500 1986 219 1 1 35 1 1992 1959 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2532 1977 219 1 1  4 1 1992 1951 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2505 1987 219 1 1 50 1 1992 1965 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2391 1991 219 1 1 19 1 1992 1958 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2363 1978 219 1 1 23 1 1992 1952 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2314 1984 219 1 1 25 1 1992 1953 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
93736 1993 219 1 1  4 1 1999 1968 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2363 1978 219 1 1 23 1 1992 1952 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2370 1982 219 1 1 31 1 1992 1948 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2515 1991 219 1 1 19 1 1992 1969 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2324 1984 219 1 1 25 1 1992 1958 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2408 1975 219 1 1  8 1 1992 1949 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2472 1981 219 1 1 30 1 1992 1958 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2527 1990 219 1 1 21 1 1992 1961 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2362 1987 219 1 1 50 1 1992 1964 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2316 1987 219 1 1 50 1 1992 1950 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2360 1988 219 1 1 31 1 1992 1963 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
93731 1995 219 1 1  5 1 1999 1970 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2339 1978 219 1 1 23 1 1992 1952 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2504 1976 219 1 1 10 1 1992 1950 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2478 1976 219 1 1 10 1 1992 1944 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2356 1990 219 1 1 21 1 1992 1966 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2403 1975 219 1 1  8 1 1992 1952 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2391 1991 219 1 1 19 1 1992 1958 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2384 1982 219 1 1 31 1 1992 1962 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2410 1972 219 1 1  6 1 1992 1942 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2456 1981 219 1 1 30 1 1992 1956 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2324 1984 219 1 1 25 1 1992 1958 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2317 1987 219 1 1 50 1 1992 1965 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2450 1988 219 1 1 31 1 1992 1961 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2539 1986 219 1 1 35 1 1992 1962 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2477 1984 219 1 1 25 1 1992 1945 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2409 1988 219 1 1 31 1 1992 1962 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2409 1988 219 1 1 31 1 1992 1962 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2357 1988 219 1 1 31 1 1992 1958 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2401 1987 219 1 1 50 1 1992 1965 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2433 1983 219 1 1 15 1 1992 1948 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2342 1985 219 1 1 16 1 1992 1948 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2477 1984 219 1 1 25 1 1992 1945 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2478 1976 219 1 1 10 1 1992 1944 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2485 1991 219 1 1 19 1 1992 1965 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2437 1982 219 1 1 31 1 1992 1960 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2391 1991 219 1 1 19 1 1992 1958 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2501 1988 219 1 1 31 1 1992 1959 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2338 1982 219 1 1 31 1 1992 1954 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2414 1985 219 1 1 16 1 1992 1957 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2401 1987 219 1 1 50 1 1992 1965 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2501 1988 219 1 1 31 1 1992 1959 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 4217 1990 219 1 1 21 1 1992 1959 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
93736 1993 219 1 1  4 1 1999 1968 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2407 1990 219 1 1 21 1 1992 1957 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2525 1979 219 1 1 19 1 1992 1947 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2525 1979 219 1 1 19 1 1992 1947 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2470 1988 219 1 1 31 1 1992 1967 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2541 1981 219 1 1 30 1 1992 1955 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2318 1976 219 1 1 10 1 1992 1956 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2329 1988 219 1 1 31 1 1992 1962 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2432 1992 219 1 1 21 1 1992 1955 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2478 1976 219 1 1 10 1 1992 1944 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2480 1987 219 1 1 50 1 1992 1967 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2488 1986 219 1 1 35 1 1992 1964 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2454 1981 219 1 1 30 1 1992 1957 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2507 1986 219 1 1 35 1 1992 1958 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2359 1991 219 1 1 19 1 1992 1957 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2459 1982 219 1 1 31 1 1992 1959 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2505 1987 219 1 1 50 1 1992 1965 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2540 1987 219 1 1 50 1 1992 1962 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2316 1987 219 1 1 50 1 1992 1950 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2544 1979 219 1 1 19 1 1992 1955 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2331 1990 219 1 1 21 1 1992 1966 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2433 1983 219 1 1 15 1 1992 1948 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2332 1978 219 1 1 23 1 1992 1946 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2505 1987 219 1 1 50 1 1992 1965 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2516 1986 219 1 1 35 1 1992 1960 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2346 1987 219 1 1 50 1 1992 1946 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2324 1984 219 1 1 25 1 1992 1958 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 4202 1985 219 1 1 16 1 1992 1955 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2530 1991 219 1 1 19 1 1992 1967 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2425 1992 219 1 1 21 1 1992 1969 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2318 1976 219 1 1 10 1 1992 1956 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
93722 1983 219 1 1 15 1 1999 1954 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2491 1974 219 1 1  5 1 1992 1948 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2522 1986 219 1 1 35 1 1992 1962 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2380 1978 219 1 1 23 1 1992 1949 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2372 1985 219 1 1 16 1 1992 1957 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
93731 1995 219 1 1  5 1 1999 1970 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
93736 1993 219 1 1  4 1 1999 1968 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2432 1992 219 1 1 21 1 1992 1955 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
93722 1983 219 1 1 15 1 1999 1954 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2370 1982 219 1 1 31 1 1992 1948 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2539 1986 219 1 1 35 1 1992 1962 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
 2544 1979 219 1 1 19 1 1992 1955 "Adilabad" "India" "356" "002019" "999" 2 "andhra pradesh"
end
label values v316 v316
label values state state
label def state 1 "andhra pradesh", modify
label values yearoi v007

Thanks a lot,

Lori

[Lorien Nair]

I managed to write a for loop but I am not entirely certain if this is the right way to go about getting the desired output.

forval i = 1960(1)1998{
    gen dist`i' = dist_sterilzn if v316 == `i'
}

----------------------- copy starting from the next line -----------------------

* Example generated by -dataex-. To install: ssc install dataex
clear
input float(dist1960 dist1961 dist1962 dist1963 dist1964 dist1965 dist1966 dist1967 dist1968 dist1969 dist1970)
3 . . . . . . . . . .
3 . . . . . . . . . .
3 . . . . . . . . . .
2 . . . . . . . . . .
2 . . . . . . . . . .
. . 2 . . . . . . . .
. . 2 . . . . . . . .
. . . 4 . . . . . . .
. . . 4 . . . . . . .
. . . 4 . . . . . . .
. . . 4 . . . . . . .
. . . 3 . . . . . . .
. . . 3 . . . . . . .
. . . 3 . . . . . . .
. . . . 3 . . . . . .
. . . . 3 . . . . . .
. . . . 3 . . . . . .
. . . . 3 . . . . . .
. . . . 3 . . . . . .
. . . . 3 . . . . . .
. . . . 5 . . . . . .
. . . . 5 . . . . . .
. . . . 5 . . . . . .
. . . . 5 . . . . . .
. . . . 5 . . . . . .
. . . . 3 . . . . . .
. . . . 3 . . . . . .
. . . . 3 . . . . . .
. . . . 1 . . . . . .
. . . . . 1 . . . . .
. . . . . 4 . . . . .
. . . . . 4 . . . . .
. . . . . 4 . . . . .
. . . . . 4 . . . . .
. . . . . 2 . . . . .
. . . . . 2 . . . . .
. . . . . 2 . . . . .
. . . . . 2 . . . . .
. . . . . 3 . . . . .
. . . . . 3 . . . . .
. . . . . 3 . . . . .
. . . . . 2 . . . . .
. . . . . 2 . . . . .
. . . . . 5 . . . . .
. . . . . 5 . . . . .
. . . . . 5 . . . . .
. . . . . 5 . . . . .
. . . . . 5 . . . . .
. . . . . 3 . . . . .
. . . . . 3 . . . . .
. . . . . 3 . . . . .
. . . . . . 2 . . . .
. . . . . . 2 . . . .
. . . . . . 4 . . . .
. . . . . . 4 . . . .
. . . . . . 4 . . . .
. . . . . . 4 . . . .
. . . . . . 2 . . . .
. . . . . . 2 . . . .
. . . . . . 2 . . . .
. . . . . . 2 . . . .
. . . . . . 3 . . . .
. . . . . . 3 . . . .
. . . . . . 3 . . . .
. . . . . . 2 . . . .
. . . . . . 2 . . . .
. . . . . . 1 . . . .
. . . . . . 5 . . . .
. . . . . . 5 . . . .
. . . . . . 5 . . . .
. . . . . . 5 . . . .
. . . . . . 5 . . . .
. . . . . . 4 . . . .
. . . . . . 4 . . . .
. . . . . . 4 . . . .
. . . . . . 4 . . . .
. . . . . . 3 . . . .
. . . . . . 3 . . . .
. . . . . . 3 . . . .
. . . . . . 4 . . . .
. . . . . . 4 . . . .
. . . . . . 4 . . . .
. . . . . . 4 . . . .
. . . . . . 4 . . . .
. . . . . . 4 . . . .
. . . . . . 4 . . . .
. . . . . . 4 . . . .
. . . . . . 5 . . . .
. . . . . . 5 . . . .
. . . . . . 5 . . . .
. . . . . . 5 . . . .
. . . . . . 5 . . . .
. . . . . . . 2 . . .
. . . . . . . 2 . . .
. . . . . . . 3 . . .
. . . . . . . 3 . . .
. . . . . . . 3 . . .
. . . . . . . 2 . . .
. . . . . . . 2 . . .
. . . . . . . 4 . . .
end

Thanks a lot,

Lori

[Mike Lacy]

You seem to want to aggregate your data from having person-years as observations to having district-years as observations. -reshape- would be a secondary consideration. Such aggregations in Stata are what the -contract- and -collapse- commands are for. I believe you want to start with contract and then reshape. Look at -help contract- and try something like this:

contract sterilization districtia v316, freq(number)
reshape wide number, i(districtia) j(v316)

Note that your data example only includes one district, which is not optimal for seeing how this works with multiple districts.

[Lorien Nair]

Thank you, Mike. The code worked very well. And apologies for not posting more data on districtia.

[Lorien Nair]

My apologies, I accidentally published it without my follow up question for Mike, I have pasted new districts besides just the one. (I think I might have deleted my question while copying and pasting my response.

I had created a similar variable that you created using contract like this:

egen dist_sterilzn = total(sterilzn_intens), by (v316 districtia)

I am not certain if this code achieves the same result that your code with contract produces. Do let me know if this looks sound.

I think my issue now is that:

I got the district-year aggregate and I merged it to the master dataset since I had lost some key variables while reshaping and contracting. But the districts naturally appear multiple times, but since I need only one obs per district, plus another variable on sterilization, do I collapse again?

* Example generated by -dataex-. To install: ssc install dataex
clear
input int districtia float dist_sterilzn long state float newid int v316 str30 district_labels int(distfreq1989 distfreq1990 distfreq1991 distfreq1992 distfreq1993)
201 31 1    53 1986 "Srikakulam" 25 15 14 18 19
201 25 1    29 1989 "Srikakulam" 25 15 14 18 19
201 25 1 92746 1989 "Srikakulam" 25 15 14 18 19
201 15 1 92764 1979 "Srikakulam" 25 15 14 18 19
201 25 1 92748 1989 "Srikakulam" 25 15 14 18 19
201  9 1    61 1987 "Srikakulam" 25 15 14 18 19
201 12 1    55 1984 "Srikakulam" 25 15 14 18 19
201 18 1 89865 1992 "Srikakulam" 25 15 14 18 19
201 18 1 90110 1992 "Srikakulam" 25 15 14 18 19
201 31 1 92750 1986 "Srikakulam" 25 15 14 18 19
201  9 1 92745 1987 "Srikakulam" 25 15 14 18 19
201 31 1 92759 1986 "Srikakulam" 25 15 14 18 19
201 15 1 90168 1990 "Srikakulam" 25 15 14 18 19
201 31 1 90105 1986 "Srikakulam" 25 15 14 18 19
201  5 1    31 1974 "Srikakulam" 25 15 14 18 19
201 19 1 89973 1993 "Srikakulam" 25 15 14 18 19
201 18 1 90065 1992 "Srikakulam" 25 15 14 18 19
201 18 1 92747 1983 "Srikakulam" 25 15 14 18 19
201 18 1    59 1983 "Srikakulam" 25 15 14 18 19
201 15 1 90108 1990 "Srikakulam" 25 15 14 18 19
201 11 1 90158 1998 "Srikakulam" 25 15 14 18 19
201  3 1     6 1964 "Srikakulam" 25 15 14 18 19
201 18 1    57 1983 "Srikakulam" 25 15 14 18 19
201 31 1    42 1986 "Srikakulam" 25 15 14 18 19
201 18 1 90089 1983 "Srikakulam" 25 15 14 18 19
201 31 1    42 1986 "Srikakulam" 25 15 14 18 19
201 31 1 90105 1986 "Srikakulam" 25 15 14 18 19
202 32 1 92785 1981 "Vizianagaram" 36 49 30 9 10
202 10 1 92779 1993 "Vizianagaram" 36 49 30 9 10
202 10 1 92789 1974 "Vizianagaram" 36 49 30 9 10
202  6 1   154 1980 "Vizianagaram" 36 49 30 9 10
202 32 1 92785 1981 "Vizianagaram" 36 49 30 9 10
202 35 1   184 1988 "Vizianagaram" 36 49 30 9 10
202 59 1    66 1987 "Vizianagaram" 36 49 30 9 10
202 59 1   200 1987 "Vizianagaram" 36 49 30 9 10
202 47 1 90119 1982 "Vizianagaram" 36 49 30 9 10
202  3 1 92782 1997 "Vizianagaram" 36 49 30 9 10
203 13 1  3433 1977 "Visakhapatnam" 37 34 21 29 8
203  2 1 89938 1998 "Visakhapatnam" 37 34 21 29 8
203 29 1  3411 1978 "Visakhapatnam" 37 34 21 29 8
203  7 1   245 1971 "Visakhapatnam" 37 34 21 29 8
203 34 1   295 1990 "Visakhapatnam" 37 34 21 29 8
203 50 1   238 1986 "Visakhapatnam" 37 34 21 29 8
203 29 1 92828 1978 "Visakhapatnam" 37 34 21 29 8
203 42 1   344 1988 "Visakhapatnam" 37 34 21 29 8
203 42 1  3447 1988 "Visakhapatnam" 37 34 21 29 8
203 29 1   301 1978 "Visakhapatnam" 37 34 21 29 8
203 42 1  3459 1988 "Visakhapatnam" 37 34 21 29 8
203 10 1 90013 1995 "Visakhapatnam" 37 34 21 29 8
203 29 1 92828 1978 "Visakhapatnam" 37 34 21 29 8
203 34 1 90023 1990 "Visakhapatnam" 37 34 21 29 8
203 42 1   335 1988 "Visakhapatnam" 37 34 21 29 8
203 24 1 89933 1987 "Visakhapatnam" 37 34 21 29 8
203 21 1  3418 1983 "Visakhapatnam" 37 34 21 29 8
203  5 1   316 1984 "Visakhapatnam" 37 34 21 29 8
203 42 1  3449 1988 "Visakhapatnam" 37 34 21 29 8
end
label values state state
label def state 1 "andhra pradesh", modify
label values v316 v316

Thank you so much for your help.