The index() function can be used to find strings in another string. Use it in a where condition in a proc sql join. For more detailed help, post example data in a usable form (see my footnotes) ... View more

See if this example gives you enough clues to get the floor, flat and building information. If this works the district should be easy enough using the patterns here. (Hint: index looking for 'District')   This relies on the Floor information ALWAYS as the 3rd element, always has a / in the middle, room is always second item, that building is the bit after the floor information and spaces always separate them. data example; address_1='ROOM 10 1/F ABC BLDG'; length floor flat $ 5 ; floor= scan(scan(address_1,3,' '),1,'/'); flat = scan(address_1,2,' '); building = substr(address_1, index(address_1,scan(address_1,4,' '))); run; ... View more