Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

devon59 (TechnicalUser)
15 Aug 09 17:44
Hi, I am having a problem importing the data from a fixed format text file.  The total width of the records is 2309 characters.  The owner of the text file said the data is one row per record ID.  However, when I open the data to look in Notepad, it seems that the data is 3 rows per ID.  I am not sure if notepad is just showing it that way and the data is really 3 rows per ID.  In any case, I am unsuccessfully importing this data.  Could anyone help please?  I could email you sample data file and a layout if it's more convenient than just what I copied and pasted below.  Thank you
/********************* sample 1 record of data*********/
 
Hinesville          GA3131391230305223202OV 1073 DESERT SHIELD
ST   
1C  
B0003600000960000...7901020214  
31.810958- 81.60928891488389640000 B41



/********************** import code that I use *****/
data T                              ;
infile 'z:\AUX_20090813.txt' ;
INPUT
FILLER_A $ 1-40
FILLER_B $ 41-80
FILLER_C $ 81-120
CITY $ 121-140
STATE $ 141-142
ZIP $ 143-147
ZIP4 $ 148-151
NameID $ 152-161
ADDRESS_SOURCE $ 162-162
ADDRESS_STATUS $ 163-163
PANDER_CODE $ 164-164
LOCAL_ADDRESS $ 165-204
UNIT_INFORMATION $ 205-217
SECONDARY_ADDRESS $ 218-257
LONG_CITY_NAME $ 258-285
SHORT_CITY_NAME $ 286-298
STATE_ABBREVIATION $ 299-300
ZIP_CODE $ 301-305
ZIP4_CODE $ 306-309
RESERVED_1 $ 310-323
RESERVED_2 $ 324-325
MILITARY_ZIP_CODE $ 326-326
OPAC_INDICATOR $ 327-327
NDI_AFFIRMED_APT $ 328-328
SECONDARY_INDICATOR $ 329-329
STATE_CODE $ 330-331
COUNTY_CODE $ 332-334
LONG_CITY_INDICATOR $ 335-335
CARRIER_ROUTE $ 336-339
LOT_NUMBER $ 340-344
LOT_SORTATION_NUMBER $ 345-346
PRESTIGE_CITY $ 347-347
DELIVERY_POINT $ 348-359

ETHNIC_CODE $ 360-361
RELIGION_CODE $ 362-362
GROUP_CODE $ 363-363
SPOKEN_LANGUAGE $ 364-365
COUNTRY_ORIGIN $ 366-367

APPAREL $ 368-368
APPACC $ 369-369
APPKIDS $ 370-370
APPMEN $ 371-371
MENFASH $ 372-372
APPWOMEN $ 373-373
WOMENFS $ 374-374
AUTO $ 375-375
RACING $ 376-376
TRUCKS $ 377-377
AVIATION $ 378-378
BARGAINS $ 379-379
BEAUTY $ 380-380
BIBLE $ 381-381
BIRDS $ 382-382
BUSINESS $ 383-383
HOMEOFF $ 384-384
BUYINT $ 385-385
CATALOG $ 386-386
COLLECT $ 387-387
STAMPS $ 388-388
COLLEGE $ 389-389
COMPUTER $ 390-390
COOKING $ 391-391
GOURMET $ 392-392
CRAFTS $ 393-393
CROCHET $ 394-394
KNIT $ 395-395
NEEDLEPT $ 396-396
QUILT $ 397-397
SEW $ 398-398
ARTS $ 399-399
CUREVENT $ 400-400
YOURSELF $ 401-401
DONOR $ 402-402
EGO $ 403-403
ELECTRON $ 404-404
HORSES $ 405-405
AFRAMR $ 406-406
ASIAN $ 407-407
HISPANIC $ 408-408
FAMILY $ 409-409
CREDITCD $ 410-410
MONEY $ 411-411
PERSONAL $ 412-412
STOCKS $ 413-413
FOREIGN $ 414-414
GAMBLE $ 415-415
GAMES $ 416-416
GARDEN $ 417-417
GIFTGVER $ 418-418
HEALTH $ 419-419
DIET $ 420-420
FITNESS $ 421-421
MOB $ 422-422
HISTORY $ 423-423
HISTAMER $ 424-424
HOBBIES $ 425-425
HOMEDECO $ 426-426
HUMOR $ 427-427
INSPIRE $ 428-428
INTERNET $ 429-429
INTACC $ 430-430
HIGHTECH $ 431-431
MTRCYCLE $ 432-432
MUSIC $ 433-433
OCEAN $ 434-434
OUTDOORS $ 435-435
BOATING $ 436-436
CAMPING $ 437-437
FISHING $ 438-438
HUNTING $ 439-439
HUNTFISH $ 440-440
PETS $ 441-441
CATS $ 442-442
DOGS $ 443-443
PHOTO $ 444-444
PROCESS $ 445-445
POLITIC $ 446-446
LIBERAL $ 447-447
PUBLISH $ 448-448
BOOKS $ 449-449
FICTION $ 450-450
MAGAZINE $ 451-451
NONFICT $ 452-452
SCIFI $ 453-453
RURAL $ 454-454
SCIENCE $ 455-455
SENIORS $ 456-456
SPORTS $ 457-457
BASEBALL $ 458-458
BASKBALL $ 459-459
FOOTBALL $ 460-460
GOLF $ 461-461
HOCKEY $ 462-462
SKI $ 463-463
SOCCER $ 464-464
TENNIS $ 465-465
STATION $ 466-466
SWEEPS $ 467-467
VCR $ 468-468
TOBACCO $ 469-469
TRAVEL $ 470-470
CRUISE $ 471-471
TRAVELRV $ 472-472
TRAVELUS $ 473-473
MOVIES $ 474-474
WILDLIFE $ 475-475

MTCHCODE $ 476-493
STABBR $ 494-495
ZIP_4 $ 496-499
Z4MATLVL $ 500-500

FILLER_1 $ 501-501

USPSDST $ 502-502
CRRT $ 503-506
DELPNT $ 507-509
CITYNAME $ 510-522
LOCTYPE $ 523-523
LOCID $ 524-535
ADDR $ 536-536
HOUSE_ $ 537-546
FRACTION $ 547-549
STPREDIR $ 550-551
STNAME $ 552-579
STSFX $ 580-583
STPSTDIR $ 584-585
ROUTETYP $ 586-586
ROUTE_ $ 587-589
BOXTYP $ 590-590
BOX_ $ 591-596
UNITTYP $ 597-600
UNIT_ $ 601-608
NREG $ 609-609
NRANK $ 610-610
TIMEZONE $ 611-611
TELSRCAT $ 612-612
TELECNT $ 613-613
DUSIZE $ 614-615
HOMEOWNR $ 616-616
HMAGESRC $ 617-617
HOMEAGE $ 618-620
HMVALSRC $ 621-621
HOMEVAL $ 622-622
LTVRANG $ 623-623
LOANAMT $ 624-628
MORAMSRC $ 629-629

FILLER_2 $ 630-630

EQUITEST $ 631-631
HOMEOWNS $ 632-632
HSEHLDID $ 633-644
SUBHHLD $ 645-645
DROP $ 646-646

FILLER_3 $ 647-647
MAILABILITY_SCORE $ 648-649
FILLER_4 $ 650-650

ARCHIVED $ 651-651
LISTTYPE $ 652-653

FILLER_5 $ 654-666

LOR $ 667-668
AGESRC $ 669-669
AGEC $ 670-670
GENDER1 $ 671-671
TITLE1 $ 672-672
GIVEN1 $ 673-687
MI1 $ 688-688
SURNM1 $ 689-708
SUFFX1 $ 709-710
HHMCNT $ 711-711
ADULTNM_ $ 712-712
CHILDCNT $ 713-713
RSCHFMCT $ 714-716
MARRIED $ 717-717
RSCHFMR $ 718-720
GPINHSE $ 721-721
OCCUPATF $ 722-723
OCCUPATM $ 724-725
OWNRENT $ 726-726
RSCHINC $ 727-732
EXPIRANK $ 733-733
WLTHFIND $ 734-734

FILLER_6 $ 735-737

PIC $ 738-739
REVOLVER $ 740-741
BBC2004 $ 742-743
INETUSE $ 744-745
HTIA $ 746-746

FILLER_7 $ 747-747

STOCKBND $ 748-748
MAILORD $ 749-749
MR_CURR $ 750-750
MR_PREV $ 751-751
MR_EVER $ 752-752
CONTBHLT $ 753-753
CONTBPOL $ 754-754
CONTBREL $ 755-755
CAT $ 756-756
DOG $ 757-757
TECARD $ 758-758
BANKCARD $ 759-759
ACTVBANK $ 760-760
ACTVCNSR $ 761-761
RSCHCRI $ 762-775
AG0_5 $ 776-776
AG0_11 $ 777-777
AG0_17 $ 778-778
AG6_11 $ 779-779
AG12_17 $ 780-780
AG12_17F $ 781-781
AG12_17M $ 782-782
AG18_24F $ 783-783
AG18_24M $ 784-784
AG18_34F $ 785-785
AG18_34M $ 786-786
AG18_44F $ 787-787
AG25_34F $ 788-788
AG25_34M $ 789-789
AG35_44F $ 790-790
AG35_44M $ 791-791
AG35_54F $ 792-792
AG35_54M $ 793-793
AG45_54F $ 794-794
AG45_54M $ 795-795
AG50_ $ 796-796
AG55_64F $ 797-797
AG55_64M $ 798-798
AG65_ $ 799-799
HHSIZE12 $ 800-800
HHSIZE3_ $ 801-801
CENS2000 $ 802-813

D2MATLVL $ 814-814
A0005PHH $ 815-819
A0017PHH $ 820-826
A0611PHH $ 827-833
A1217FHH $ 834-840
A1217MHH $ 841-847
A1217PHH $ 848-854
A1824FHH $ 855-861
A1824MHH $ 862-868
A2534FHH $ 869-875
A2534MHH $ 876-882
A3544FHH $ 883-889
A3544MHH $ 890-896
A4554FHH $ 897-903
A4554MHH $ 904-910
A5564FHH $ 911-917
A5564MHH $ 918-924
A65UPFHH $ 925-931
A65UPMHH $ 932-938
AGE_MED $ 939-943
AGE_MEDF $ 944-948
AGE_MEDM $ 949-953
AGEMEDAD $ 954-958
AGEMEDAF $ 959-963
AGEMEDAM $ 964-968
AGP00_05 $ 969-973
AGP00_11 $ 974-978
AGP00_17 $ 979-983
AGP06_11 $ 984-988
AGP12_17 $ 989-993
AGP18_24 $ 994-998
AGP18_34 $ 999-1003
AGP25_34 $ 1004-1008
AGP35_44 $ 1009-1013
AGP35_54 $ 1014-1018
AGP45_54 $ 1019-1023
AGP50_64 $ 1024-1028
AGP50UP $ 1029-1033
AGP55_64 $ 1034-1038
AGP65_74 $ 1039-1043
AGP65UP $ 1044-1048
AGP75UP $ 1049-1053
AHP65UP $ 1054-1058
EAASIAN $ 1059-1063
EABLACK $ 1064-1068
EAHISP $ 1069-1073
EAWHITE $ 1074-1078
EPASIAN $ 1079-1083
EPBLACK $ 1084-1088
EPCHINSE $ 1089-1093
EPHCENAM $ 1094-1098
EPHCUBAN $ 1099-1103
EPHISP $ 1104-1108
EPHMEX $ 1109-1113
EPHMIX $ 1114-1118
EPHPRICO $ 1119-1123
EPHSOAMR $ 1124-1128
EPHWHITE $ 1129-1133
EPINDIA $ 1134-1138
EPJAPANS $ 1139-1143
EPKOREAN $ 1144-1148
EPMIX $ 1149-1153
EPVIETNM $ 1154-1158
EPWHITE $ 1159-1163
FAMSIZE $ 1164-1168
FBAFRICA $ 1169-1173
FBASIA $ 1174-1178
FBCITIZN $ 1179-1183
FBLATNAM $ 1184-1188
FBNONCIT $ 1189-1193
FBNORTAM $ 1194-1198
FBORNPCT $ 1199-1203
FLANGPCT $ 1204-1208
FLASAPAC $ 1209-1213
FLSPAN $ 1214-1218
HFAMILY $ 1219-1223
HFGCHILD $ 1224-1228
HFPARENT $ 1229-1233
HHCHILD $ 1234-1238
HHFEM1P $ 1239-1243
HHFEMHH $ 1244-1248
HHMARNOC $ 1249-1253
HHMARWCH $ 1254-1258
HHSGLHFC $ 1259-1263
HHSGLHH $ 1264-1268
HHSGLHM $ 1269-1273
HHSGLHMC $ 1274-1278
HHSINGLE $ 1279-1283
HHSIZE $ 1284-1288
HHSIZEOO $ 1289-1293
HHSIZERO $ 1294-1298
HPARTNRS $ 1299-1303
HPFHFP $ 1304-1308
HPFHMP $ 1309-1313
HPMHFP $ 1314-1318
HPMHMP $ 1319-1323
HS1P $ 1324-1328
HS2P $ 1329-1333
HS3PUP $ 1334-1338
HS4PUP $ 1339-1343
HS5PUP $ 1344-1348
HUOCCPCT $ 1349-1353
HUOOPCT $ 1354-1358
IH_0_10K $ 1359-1363
IH_0_25K $ 1364-1368
IH_35KUP $ 1369-1373
IH_50KUP $ 1374-1378
IH_75KUP $ 1379-1383
IH10012K $ 1384-1388
IH125150 $ 1389-1393
IH150200 $ 1394-1398
IH200KUP $ 1399-1403
IMAG0024 $ 1404-1410
IMAG2534 $ 1411-1417
IMAG3544 $ 1418-1424
IMAG4554 $ 1425-1431
IMAG5564 $ 1432-1438
IMAG6574 $ 1439-1445
IMAG75UP $ 1446-1452
IMASIAN $ 1453-1459
IMBLACK $ 1460-1466
IMHISP $ 1467-1473
IMWHITE $ 1474-1480
INFMED $ 1481-1487
INHH_AVG $ 1488-1494
INHH_MED $ 1495-1501
INPERCAP $ 1502-1508
IPCASIAN $ 1509-1515
IPCBLACK $ 1516-1522
IPCHISP $ 1523-1529
IPCWHITE $ 1530-1536
IPOVERTY $ 1537-1541
ITHHIDR $ 1542-1546
ITHHPUB $ 1547-1551
ITHHRET $ 1552-1556
ITIDR $ 1557-1561
ITSOCSEC $ 1562-1566
L65UPA $ 1567-1571
MDIVRCED $ 1572-1576
MDIVRCEF $ 1577-1581
MDIVRCEM $ 1582-1586
MSINGLE $ 1587-1591
MSINGLEF $ 1592-1596
MSINGLEM $ 1597-1601
POPDENS $ 1602-1610
POPPCTF $ 1611-1615
POPPCTM $ 1616-1620
POPURBAN $ 1621-1625
RCMPIOOM $ 1626-1630
RCPTAXM $ 1631-1635
RCR_99 $ 1636-1640
RCR1KUP $ 1641-1645
RCR2KUP $ 1646-1650
RCRMED $ 1651-1655
RHCOAL $ 1656-1660
RHELEC $ 1661-1665
RHLPGAS $ 1666-1670
RHNATGAS $ 1671-1675
RHNONE $ 1676-1680
RHOIL $ 1681-1685
RHSOLAR $ 1686-1690
RHWOOD $ 1691-1695
RMDYRIN $ 1696-1700
RPERRM $ 1701-1703
RPR1UP $ 1704-1708
RS1RM $ 1709-1713
RS4BRUP $ 1714-1718
RS5BRUP $ 1719-1723
RS6RMUP $ 1724-1728
RS9RMUP $ 1729-1733
RSMEDRMS $ 1734-1736
RT_1U $ 1737-1741
RT_1UA $ 1742-1746
RT_2U $ 1747-1751
RT10UUP $ 1752-1756
RT50UUP $ 1757-1761
RTMOBLHM $ 1762-1766
RTOO1U $ 1767-1771
RTRO1U $ 1772-1776
RUVACSEA $ 1777-1781
RV_0_150 $ 1782-1786
RV_0_15K $ 1787-1791
RV_0_50K $ 1792-1796
RV_1520K $ 1797-1801
RV_2025K $ 1802-1806
RV_70100 $ 1807-1811
RV100KUP $ 1812-1816
RV1MMUP $ 1817-1821
RV200KUP $ 1822-1826
RV300KUP $ 1827-1831
RV400KUP $ 1832-1836
RV500KUP $ 1837-1841
RV7501MM $ 1842-1846
RVAVGOON $ 1847-1853
RVMEDOO $ 1854-1860
RYB95_2K $ 1861-1865
RYB99_2K $ 1866-1870
RYBMED $ 1871-1875
RYBPRE50 $ 1876-1880
SCOLGRAD $ 1881-1885
SDEGAA $ 1886-1890
SDEGBA $ 1891-1895
SDEGDOC $ 1896-1900
SDEGMA $ 1901-1905
SDEGPROF $ 1906-1910
SE912PVT $ 1911-1915
SECOLL $ 1916-1920
SEK12PVT $ 1921-1925
SEPRESCH $ 1926-1930
SHSCOLL $ 1931-1935
SHSGRAD $ 1936-1940
SNONHSG $ 1941-1945
SYRSMED $ 1946-1950
V1HH $ 1951-1955
V2HH $ 1956-1960
V3HH $ 1961-1965
VPERHH $ 1966-1968
W2FAMMEM $ 1969-1973
WEMPLPCT $ 1974-1978
WFLABOR $ 1979-1983
WFMOMS $ 1984-1988
WFPARTTM $ 1989-1993
WFUNEMP $ 1994-1998
WHOMEPCT $ 1999-2003
WIAERAFS $ 2004-2008
WIAFFHM $ 2009-2013
WICONST $ 2014-2018
WIEHSS $ 2019-2023
WIFIRERL $ 2024-2028
WIINFO $ 2029-2033
WIMFG $ 2034-2038
WIOSVC $ 2039-2043
WIPROF $ 2044-2048
WIPUBAD $ 2049-2053
WIRETAIL $ 2054-2058
WITWU $ 2059-2063
WIWHLSL $ 2064-2068
WO_BLUC $ 2069-2073
WO_WHTC $ 2074-2078
WOAESM $ 2079-2083
WOARCENG $ 2084-2088
WOBUSFIN $ 2089-2093
WOCOMPUT $ 2094-2098
WOCONMNT $ 2099-2103
WOCONST $ 2104-2108
WOCUSTDL $ 2109-2113
WOEDUC $ 2114-2118
WOFARMR $ 2119-2123
WOFFF $ 2124-2128
WOFOODRL $ 2129-2133
WOHLTHPT $ 2134-2138
WOHLTHSP $ 2139-2143
WOIMR $ 2144-2148
WOLEGAL $ 2149-2153
WOMGT $ 2154-2158
WOMGTPRO $ 2159-2163
WOOFFADM $ 2164-2168
WOPERSVC $ 2169-2173
WOPROD $ 2174-2178
WOPROF $ 2179-2183
WOPROFT $ 2184-2188
WOPROTSV $ 2189-2193
WOPTMTRL $ 2194-2198
WOPVT4P $ 2199-2203
WOSALESO $ 2204-2208
WOSALESR $ 2209-2213
WOSCI $ 2214-2218
WOSOCSVC $ 2219-2223
WOSVC $ 2224-2228
WOTRANSM $ 2229-2233
WPUBTRAN $ 2234-2238
WPVTTRAN $ 2239-2243
WSELFEMP $ 2244-2248
WTRAVLTM $ 2249-2251
WUNEMP $ 2252-2256

CENSUS_STATE $ 2257-2258
CENSUS_COUNTY $ 2259-2261
CENSUS_TRACT $ 2262-2267
CENSUS_BG $ 2268-2268
CENSUS_LEVEL $ 2269-2269
LATITUDE $ 2270-2280
LONGITUDE $ 2281-2291
MCD $ 2292-2296
PLACE $ 2297-2301
MSA $ 2302-2305
EXPANSION $ 2306-2306
SESI2000 $ 2307-2310
;
RUN;
 
jdvtr (Programmer)
17 Aug 09 6:14
This might point you in the right direction:

http://www.albany.edu/~msz03/epi514/papers/truncover.pdf

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close