Dear All, I have a Dataset which has CompanyNames in it. However the challenge here is that Company names slightly differ to each other although all belongs to one company only. For example if you see below 1 800 FLOWERS and 1 800 FLOWERS COM CL A and 1-800-FLOWERS.COM INC and 1-800-FLOWERS.COM INC-CL A and 1-800-FLOWERS.COM INC. CLASS are all same. Hence I am trying to bring all these names under one name so that they are consistent. In this case it will be 1 800 FLOWERS. Please help me how to achieve this task through SAS program. For easy access I have made the program readily available here. I truly appreciate your timely help. Data Fix_CompanyNames; input Company $28.; Infile cards; cards; 1 800 FLOWERS 1 800 FLOWERS COM CL A 1-800-FLOWERS.COM INC 1-800-FLOWERS.COM INC-CL A 1-800-FLOWERS.COM INC. CLASS 1347 PPTY INS HLDGS INC 180 DEGREE CAP CORP 180 DEGREE CAPITAL CORP 1ST CONSTITUTION BANCORP 1ST SOURCE CORP 1ST SOURCE CORP COM 21VIANET GROUP INC 21VIANET GROUP INC - ADR 21VIANET GROUP INC ADR 21VIANET GROUP INC-ADR 22ND CENTURY GROUP INC 22ND CENTY GROUP INC 2U INC 3-D SYS CORP DEL 3-D SYS CORP DEL COM NEW 3D SYSTEMS CORP 3M CO 3M COMPANY 500 COM LTD 500.COM LTD 51JOB INC 51JOB INC ADR 51JOB INC-ADR 51JOBS INC-ADR 58 COM INC 58 COM INC ADR 58 COM INC-ADR 58.COM INC 58.COM INC A ADR 58.COM INC ADR 58.COM INC-ADR 58.COM-ADR 8 X 8 INCORPORATED 8 X 8, INCORPORATED 8POINT3 ENERGY PARTNERS LP 8X8 INC 8X8 INC NEW 8X8 INC NEW COM A H BELO CORP A H BELO CORP-A A MARK PRECIOUS METALS INC A SCHULMAN INC A-MARK PRECIOUS METALS INC SCHULMAN INC. A.O. SMITH A10 NETWORKS INC AAC HLDGS INC AAC HOLDINGS INC AAON INC AAON INC COM PAR $0.004 AAR CORP AAR CORP COM AAR CORPORATION AARON'S AARON'S INC AARONS INC AAWW 1.875 6/24 AAWW 2.25 06/22 ABAXIS INC ABAXIS INCORPORATED ABB LIMITED ADR ABB LTD ABB LTD ADR ABB LTD-ADR ABB LTD-SPON ADR ABBOTT LABORATORIES ABBOTT LABS ABBOTT LABS COM ABBVIE INC ABBVIE INC COM ABBVIE INC. ABEONA THERAPEUTICS INC ABERCROMBIE & FITCH ABERCROMBIE & FITCH CO ABERCROMBIE & FITCH CO CL A ABERCROMBIE & FITCH CO-CL A ABERCROMBIE & FITCH COMPANY- ABERCROMBIE & FITCH ABERDEEN ASIA PACIFIC INCOM ABERDEEN AUSTRALIA EQTY FD I ABERDEEN CHILE FD INC ABERDEEN CHILE FUND INC ABERDEEN EMERG ABERDEEN GLOBAL INCOME FD IN ABERDEEN GREATE ABERDEEN ISRAE ABERDEEN ISRAEL FUND INC ABERDEEN JAPAN ABERDEEN LATIN ABERDEEN LATIN AMER EQTY FD ABERDEEN SG FD ABERDEEN SINGAPORE FD INC ABILITY INC ABIOMED INC ABIOMED INC COM ABIOMED INC. ABLYNX NV ABLYNX NV - ADR ABM INDS INC ABM INDS INC COM ABM INDUSTRIES INC ABR 5.375 11/15/20 ABRAXAS PETE CORP ABRAXAS PETE CORP COM ABRAXAS PETROLEUM CORP ABSOLUTE SHS TR AC IMMUNE SA ACACIA COMMUNIC ACACIA COMMUNICATIONS INC ACACIA RESEARCH - ACACIA TEC ACACIA RESEARCH CORP ACACIA RESH CORP ACADEMY FDS TR ACADIA HEALTHCAR ACADIA HEALTHCARE ACADIA HEALTHCARE CO INC ACADIA HEALTHCARE COMPANY IN ACADIA PHARMACEUTICALS INC ACADIA PHARMACEUTICALS INC C ACADIA REALTY ACADIA REALTY TRUS ACADIA REALTY TRUST ACADIA RLTY TR ACADIA RLTY TR COM SH BEN IN ACASTI PHARMA INC ACCELERATE DIAGNOSTICS INC ACCELERON PHARMA ACCELERON PHARMA INC ACCENTURE LTD BERMUDA CL A ACCENTURE PLC ACCENTURE PLC (A) ADR ACCENTURE PLC CL A ACCENTURE PLC CLASS A ACCENTURE PLC IRELAND ACCENTURE PLC IRELAND SHARES ACCENTURE PLC IRELAND SHS ACCENTURE PLC-A ACCENTURE PLC-CL A ACCESS NATIONAL CORP ACCESS NATIONAL CORP COM ACCESS NATL CORP ACCLERATE DIAGNOSTICS INC ACCO BRANDS CORP ACCURAY INC ACELRX PHARMACEUTICALS INC ACER THERAPEUTICS INC ACETO CORP ACETO CORP COM ACHAOGEN INC ACHIEVE LIFE SCIENCE INC ACHIEVE LIFE SCIENCES INC ACHILLION PHARMACEUTICALS ACHILLION PHARMACEUTICALS IN ACHILLION PHARMACTCLS ACI WORLDWIDE INC ACLARIS THERAPE ACLARIS THERAPEUTICS INC ACME UTD CORP ACNB CORP ACOR 1.75 21 ACORDA THERAPEUTICS INC ACORN INTL INC ACRE RLTY INVS INC ACT 5.5 03/01/18 ACTINIUM PHARMACEUTICALS INC ACTIVE WEIGHTING FDS ETF TR ACTIVISION BLIZ ACTIVISION BLIZZ ACTIVISION BLIZZARD INC ACTUA CORP ACTUA CORPORATION ACTUANT CORP ACTUANT CORP CL A NEW ACTUANT CORP CLASS A ACTUANT CORP-A ACUITY BRANDS INC ACUITY BRANDS INC COM ACUITY BRANDS INC COM USD0 0 ACUSHNET HOLDINGS CORP ACXIOM ACXIOM CORP ACXIOM CORP COM ACXIOM CORPORATION ADAM NAT RES FD INC ADAMAS PHARMA ADAMAS PHARMACEUTICALS INC ADAMIS PHARMACEUTICALS CORP ADAMIS PHARMACEUTICALS INC C ADAMS DIVERSIFI ADAMS DIVERSIFIED EQUITY ADAMS DIVERSIFIED EQUITY FD ADAMS DIVERSIFIED EQUITY FUN ADAMS EXPRESS ADAMS NATURAL ADAMS NATURAL RESOURCES FUND ADAMS RES & ENERGY INC ADAMS RESOURCES & ENERGY INC ADAPTIMMUNE THERAPEUTICS - A ADAPTIMMUNE THERAPEUTICS PLC ADAPTIMMUNE THERAPEUTICS-ADR ADCARE HEALTH SYSTEMS ADCARE HEALTH SYSTEMS INC ADDUS HOMECARE CORP ADDVANTAGE TECHNOLOGIES GP I ADDVANTAGE TECHNOLOGIES GRP ADECOAGRO S A ADECOAGRO SA ; run;
... View more
