Thank you, Ksharp and Reeza. This is a sample of the custinfo data: custid,name,addr,city,st,zip,code1,code2,code3,code4 29348,Frands,101 Main,Centerville,AZ,85522,1,5,, 29074,Frenchs,108 South,Midvale,CA,92141,5,6,7, 23947,Alberts,52 Grant,Jefferson,MI,50852,4a,5,3,4a 92347,Ralphs,786 Hanley,Lewis,KS,60503,4a,2,2,1 32047,Kroger,567 Frost,Scottsdale,TX,45221,6,4a,7,6 29347,AP,678 Barton,Phoenix,AZ,84502,9,B8,4a, 94594,Aldi,901 Wilson,Mesa,AZ,86522,2,1,5,4a 93475,Meijer,345 12th,San Dimas,CA,92622,3,3,, 93479,Bass,354 Appletree,Bernard,WA,90255,1,6,6, 47349,Culvers,987 Peartree,Manzanita,NV,81511,1,5,7, 34978,Mr B,498 Figtree,Leonard,PA,20611,5,4a,, This is an sample of the descriptions that go with the codes; some of the codes do contain characters: code,description 1,Broadway 2,Lindell 3,Chouteau 4a,Peachtree 5,Del Rey 6,Grand 7,Pershing B8,Adobe 9,Revillo 10,Menard The end result I want is to create a dataset with the following fields: custid,name,addr,city,st,zip,code1,code2,code3,code4,code1desc,code2desc,code3desc,code4desc I am working my way through the lexjansen.com paper as Reeza suggested, particularly the cntlin statement and using formats to create new variables. I really appreciate your help. I will work on this over the weekend.
... View more