I have a data set that looks like the following. ID TVG_MSO1 TVG_MSO2 TVG_MSO3 NTIA_MSO1 NTIA_MSO2 NTIA_MSO3 NTIA_MSO4 391517108002054 Comcast Cable Communications Lamont Digital Systems, Inc. Time Warner Cable AT&T Time Warner Cable NULL NULL 191130017006002 ImOn Communications, LLC Mediacom, L. L. C. NULL CenturyLink Dynamic Broadband ImOn Communications, LLC Mediacom, L. L. C. 320030016123003 CenturyLink Commercial Satellite System Cox Cable Communications Inc CenturyTel TeleVideo, Inc. Cox Cable Communications Inc NULL NULL 360450613002014 Time Warner Cable NULL NULL Time Warner Cable Verizon Service Corp WesTel Systems NULL 220550020021029 NULL NULL NULL AT&T Cox Cable Communications Inc NULL NULL 480291203002025 CS Wireless Systems, Inc. Grande ClearSource Comm. Time Warner Cable AT&T Grande ClearSource Comm. Time Warner Cable NULL 132551612001003 Comcast Cable Communications DirecPath NULL AT&T Comcast Cable Communications Covad Communications NULL 260150108002035 Wide Open West NULL NULL Barry County Telephone Company NULL NULL NULL 210490202023015 Time Warner Cable NULL NULL AT&T Time Warner Cable NULL NULL 160219702005039 NULL NULL NULL NULL NULL NULL NULL My problem is that that I need find matches where TVG_MSO1 is equal to NTIA_MSO1 or NTIA_MSO1 or NTIA_MSO2 or NTIA_MSO3 or NTIA_MSO4. But the macth could come from any combination of the TVG_ and NTIA_ columns. So for example, in the first row TVG_MSO3 equals NTIA_MSO2, so I would like to have a final column that would say the name of the match "Time Warner Cable". If there is no match, that is fine. Similarly in row two the match is TVG_MSO2 and NTIA_MSO4 and the output column would be "Mediacom, L. L. C.". If there is any one that could help me out with a solution, I would be forever grateful. Your friend in SAS, John Wynne
... View more