I am tring to import the raw data for Uniform Crime Report with ACSII data format, but they did not provide dictionary except for a codebook. But problem is in the codebook, there are three section: agency header, monthly header, and detail header. And I only have one text file, it seems like within one file, it splits three parts. I really don't know how to construct a dic file that can do all in once. Here is the dictionary I create for the third part, detail header:
Here is the first few line of the data:
I have attach the screen shot of the codebook for the first page of each part:
Agency
Monthly
Detail
Code:
*SRS dictionary
infix dictionary using 2019_ASRMONTHLY_NATIONAL_MASTER_FILE.txt{
_lrecl(471)
ASR_ID 1
STATE 2-3
str ORI 4-10
GROUP 11-12
DIV 13
MONTH 14-15
YEAR 16-17
OFFENSE 18-20
OCCUR 21-23
ARRCODE 24-26
ARRCOUNT 27-31
ARRCODE 32-34
ARRCOUNT 35-39
ARRCODE 40-42
ARRCOUNT 43-47
ARRCODE 48-50
ARRCOUNT 51-55
ARRCODE 56-58
ARRCOUNT 59-63
ARRCODE 64-66
ARRCOUNT 67-71
ARRCODE 72-74
ARRCOUNT 75-79
ARRCODE 80-82
ARRCOUNT 83-87
ARRCODE 88-90
ARRCOUNT 91-95
ARRCODE 96-98
ARRCOUNT 99-103
ARRCODE 104-106
ARRCOUNT 107-111
ARRCODE 112-114
ARRCOUNT 115-119
ARRCODE 120-122
ARRCOUNT 123-127
ARRCODE 128-130
ARRCOUNT 131-135
ARRCODE 136-138
ARRCOUNT 139-143
ARRCODE 144-146
ARRCOUNT 147-151
ARRCODE 152-154
ARRCOUNT 155-159
ARRCODE 160-162
ARRCOUNT 163-167
ARRCODE 168-170
ARRCOUNT 171-175
ARRCODE 176-178
ARRCOUNT 179-183
ARRCODE 184-186
ARRCOUNT 187-191
ARRCODE 192-194
ARRCOUNT 195-199
ARRCODE 200-202
ARRCOUNT 203-207
ARRCODE 208-210
ARRCOUNT 211-215
ARRCODE 216-218
ARRCOUNT 219-223
ARRCODE 224-226
ARRCOUNT 227-231
ARRCODE 232-234
ARRCOUNT 235-239
ARRCODE 240-242
ARRCOUNT 243-247
ARRCODE 248-250
ARRCOUNT 251-255
ARRCODE 256-258
ARRCOUNT 259-263
ARRCODE 264-266
ARRCOUNT 267-271
ARRCODE 272-274
ARRCOUNT 275-279
ARRCODE 280-282
ARRCOUNT 283-287
ARRCODE 288-290
ARRCOUNT 291-295
ARRCODE 296-298
ARRCOUNT 299-303
ARRCODE 304-306
ARRCOUNT 307-311
ARRCODE 312-314
ARRCOUNT 315-319
ARRCODE 320-322
ARRCOUNT 323-327
ARRCODE 328-330
ARRCOUNT 331-335
ARRCODE 336-338
ARRCOUNT 339-343
ARRCODE 344-346
ARRCOUNT 347-351
ARRCODE 352-354
ARRCOUNT 355-359
ARRCODE 360-362
ARRCOUNT 363-367
ARRCODE 368-370
ARRCOUNT 371-375
ARRCODE 376-378
ARRCOUNT 379-383
ARRCODE 384-386
ARRCOUNT 387-391
ARRCODE 392-394
ARRCOUNT 395-399
ARRCODE 400-402
ARRCOUNT 403-407
ARRCODE 408-410
ARRCOUNT 411-415
ARRCODE 416-418
ARRCOUNT 419-423
ARRCODE 424-426
ARRCOUNT 427-431
ARRCODE 432-434
ARRCOUNT 435-439
ARRCODE 440-442
ARRCOUNT 443-447
ARRCODE 448-450
ARRCOUNT 451-455
ARRCODE 456-458
ARRCOUNT 459-463
ARRCODE 460-462
ARRCOUNT 463-467
ARRCODE 464-466
ARRCOUNT 467-471
}
Code:
350AK001011C90019 3900 000000Y 000287731ANCHORAGE Alaska 350AK001011C90119000C 000000000000000000000010000000000000000000000000 350AK001011C901190120030360000104800001054000010000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 350AK001011C901190200060110000101400001016000010450000204700001054000030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 350AK001011C901190300150110000101400004015000020170000303000001031000010360000103700002038000020400000104500006046000040470000604800002054000180000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 350AK001011C901190400370020000100300001004000020050000100700002008000010100000201100003012000020130000101400013015000100160000901700007018000020190000402000004025000010310000103300003034000010360000303700003038000020390000304000002041000010420000104400001045000280460001304700036048000040490000105100005054000810560000600000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 350AK001011C901190500200040000100700001011000010140000501500002016000050170000101800001019000030260000103600001037000030380000104500017046000010470000504800001051000020540002405600002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 350AK001011C901190600350030000100600001007000010080000100900002010000010140000901500018016000090170000201800002019000010200000102100001024000010270000102800001031000010320000203600011037000130380000403900004040000010420000104500040046000110470003304800001049000010500000205100002053000010540008405600005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 350AK001011C901190700190030000100700001008000020130000101400003015000060160000501700001030000010340000103600002038000010450001104600005047000060480000205200001054000240560000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 350AK001011C901190800440020000300300002007000010080000200900001010000010120000501300002014000210150001801600009017000080180000501900007020000050220000202400002025000030260000402700003028000010290000103000002031000010320000303300002034000040350000103600012037000060380000703900008040000010410000304300001045000470460002404700055048000130490000805000004051000060540013905600018000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 350AK001011C901190900050140000103700001045000010470000105400002000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 350AK001011C901191000060170000101800001039000010450000204600001054000030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 350AK001011C901191100080140000203700001038000010390000104500002046000020470000105400005000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 350AK001011C901191200090110000102000001032000010340000103500001045000010460000304800001054000050000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 350AK001011C901191300100130000101400001015000010160000103800001045000010460000104700002048000010540000500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 350AK001011C901191400310030000100400001007000010080000100900002010000020110000101300003014000050150000801600003017000020180000101900001020000030310000303300001034000010360000303700003038000020390000104200001043000010450001904600003047000210480000604900002054000490560000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 350AK001011C901191500140030000101200001014000010150000201600001017000020180000102000001045000060470000104800002050000010540000905600001000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 350AK001011C901191700130050000101000001016000010170000201800003020000010210000104500003047000050480000104900001054000090550000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000 350AK001011C9011918 0310020000100300001005000010060000200700001008000020100000101300001014000040150000501600003017000040180000101900001024000010250000102600001035000020360000203800001040000010450001504600007047000030480000404900002050000020510000305200001054000290560000800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
Agency
Monthly
Detail
Attached Files
