Reshaping data to long format

[vivek narayan]

input str5 commutingzoneid byte year float(AggWagesagriforfish AggWagesBusinessandrepairserv AggWagesCommandotherpublic)
"" 80 937653376 1419469696 2162623232
"" 90 1247656960 3303077632 5402723328
"11500" 80 32260294 29582068 62534468
"11500" 90 45551160 77919896 155278496
"11600" 80 166227312 1089221504 1586686464
"11600" 90 346786304 3132709888 4255668224
"11700" 80 33854792 60524716 91582984
"11700" 90 59648684 163814768 267307392
"11900" 80 71523928 54962604 85898408
"11900" 90 111511488 127049296 240813456
"12100" 80 39144668 68105920 93775832
"12100" 90 89995544 171140240 258356032
"12200" 80 105092592 142288016 218853248
"12200" 90 200083584 436156992 572916288
"12501" 80 111137144 237554096 308874944
"12501" 90 170186560 593402368 680642624
"12701" 80 76134928 324185888 497857920
"12701" 90 169991744 853833728 1220348800
"13400" 80 50225796 26822020 31330916
"13400" 90 86302152 50750420 94856600
"13501" 80 69335392 124519280 212823568
"13501" 90 96320264 322823584 571829632
"13600" 80 51869024 82719008 121960672
"13600" 90 86644472 195840912 319736352
"13700" 80 71743672 34057864 51010796
"13700" 90 110913856 101148536 144731840
"14000" 80 41081052 39354328 62660172
"14000" 90 56093812 127546440 159483536
"14100" 80 76460384 79017616 102101552
"14100" 90 76566352 175589616 264971840
"14200" 80 94830120 241165568 362811872
"14200" 90 293643808 692904832 979502208
"14400" 80 46959576 26853428 41696148
"14400" 90 47875432 49241868 104624008
"14500" 80 51299540 26756362 34192544
"14500" 90 111241624 73528200 117748216
"14600" 80 . . .
"14600" 90 27663892 45760732 89172968
"14700" 80 123211464 51296176 85210528
"14700" 90 . . .
"14900" 80 48829040 86575072 142404000
"14900" 90 40130280 230691232 394979008
"15000" 80 100551776 103098816 153514832
"15000" 90 154936000 202761600 312654944
"15100" 80 21361558 43421416 74402480
"15100" 90 57693804 121800992 190296960
"15200" 80 98491696 546470400 801606720
"15200" 90 216531664 1179916800 1738915072
"15900" 80 107660256 334173472 466869408
"15900" 90 195950304 873045952 1281166336
"16000" 80 23189090 35191544 55623656
"16000" 90 89039920 79515208 129195304
"16100" 80 64414568 31987008 40647740
"16100" 90 45930960 63161092 82994152
"16200" 80 118138808 43615472 71509464
"16200" 90 74484720 99643296 156009888
"16300" 80 292145888 658653696 896308864
"16300" 90 178676592 1166136064 1599582720
"16400" 80 58111912 85232768 154103264
"16400" 90 92933784 178732288 317948448
"16500" 80 86314256 75052912 112103272
"16500" 90 99300472 128772928 249789712
"17100" 80 28777754 28042532 48685812
"17100" 90 . . .
"17400" 80 80518392 35310220 54739596
"17400" 90 . . .
"17700" 80 90877400 152488032 257759152
"17700" 90 182775232 389435328 660286784
"17900" 80 25283626 33040976 63368008
"17900" 90 43949864 93560488 159813072
"18000" 80 151449840 352400096 583229504
"18000" 90 260487104 839817792 1412326528
"18300" 80 60360424 12259015 21566174
"18300" 90 96914448 34711544 77278768
"18600" 80 63427520 220294288 315203488
"18600" 90 125910080 444136576 613157184
"18800" 80 47796644 78125904 120600952
"18800" 90 79667064 239675808 412441056
"18900" 80 20285468 18146280 29858008
"18900" 90 46423760 48224472 74381800
"19000" 80 . . .
"19000" 90 49813896 278358560 448704320
"19100" 80 182802336 138971472 212374928
"19100" 90 319045056 396918336 626091904
"19200" 80 111634464 131569992 219209120
"19200" 90 171842384 414633664 634702528
"19300" 80 59773628 119848512 197295024
"19300" 90 141082368 356869600 538704064
"19400" 80 197841936 3981399296 5423126528
"19400" 90 585981696 9636337664 10967245824
"19600" 80 182654288 2324475392 2929411584
"19600" 90 309250944 5591276032 5780214784
"19700" 80 227256464 1270414080 1859929216
"19700" 90 679551680 3645154048 4413547520
"22601" 80 65245024 31981552 53008912
"22601" 90 . . .
"23500" 80 105934112 43310620 75125232
"23500" 90 119548704 106886248 184183280
"23801" 80 78471928 47179460 90774720
"23801" 90 118492736 114738840 207171840
end
label values year YEAR

I need to reshape the data so that I have a column for occupation (which is the suffix in the follows the AggWages* variables) and then another one with the actual aggregate wage values. I have attempted to use the code below but I get an error saying variable j is all missing values. My code is below. Any help is appreciated!

reshape long AggWages, i(commutingzoneid year) j(occ)

[William Lisowski]

Since the occupation is a string - for example, "agriforfish" - you need to add the string option to your reshape command to tell it that the j() variable it creates will hold a string.

reshape long AggWages, i(commutingzoneid year) j(occ) string

[Clyde Schechter]

-reshape- assumes that the variable specified in the -j()- option will be numeric unless you tell it otherwise. This will work:

reshape long AggWages, i(commutingzoneid year) j(occ) string

Added: Crossed with #2 which offers the same solution with different typographical flourishes.