Dear SAS community. I have two datasets -dataset1 and dataset2 and each one of them has the following columns- ticker, companyid, comname and score. I would like to compare how similar are the two datasets. I would like to compare the ticker-companyid-score combination in both tables. I would like to create a new table that has ticker, companyid, score, and a fourth column. The fourth column is based on the following condition. If ticker-companyid-score combination is the same for both datasets, then we can call it "same, if it is only in dataset1 we can call it "dataset1" and if it is only in dataset2 we can call it "dataset2". What is the easiest way to do this?
data dataset1;
infile datalines dsd truncover;
input TICKER:$6. companyid:32. COMNAME:$32. SCORE:32.;
datalines4;
0000,14471,TALMER BANCORP INC,0
0001,14392,E P ENERGY CORP,0
0004,14418,AMERICAN CAPITAL SR FLOATING LT,0
000R,14378,CARE COM INC,0
000V,14423,EIGER BIOPHARMACEUTICALS INC,0
000Y,14436,ULTRAGENYX PHARMACEUTICALS INC,0
000Z,14449,BIOCEPT INC,0
0011,14416,C H C GROUP LTD,0
0017,14448,AUSPEX PHARMACEUTICALS INC,0
0018,14455,EGALET CORP,0
001A,14452,ELEVEN BIOTHERAPEUTICS INC,0
001C,14447,ARGOS THERAPEUTICS INC,0
001J,14487,KNOWLES CORP,0
001K,14479,INSTALLED BUILDING PRODUCTS INC,0
001L,14451,CONCERT PHARMACEUTICALS INC,0
001M,14459,INOGEN INC,0
001N,14504,QUOTIENT TECHNOLOGY INC,0
001R,12962,C S R PLC,0
001X,14550,RECRO PHARMA INC,0
001Z,14524,KING DIGITAL ENTERTAINMENT PLC,0
002G,14502,CASTLIGHT HEALTH INC,0
002J,14547,PAYLOCITY HOLDING CORP,0
002L,14499,AMBER ROAD INC,0
002P,14495,A10 NETWORKS INC,0
002S,14574,MOELIS & CO,0
002T,14503,OUTFRONT MEDIA INC,0
002U,14616,WEIBO CORP,0
002Y,14527,NORD ANGLIA EDUCATION INC,0
0031,14594,CORIUM INTERNATIONAL INC,0
0033,14578,OPOWER INC,0
0039,14573,LA QUINTA HOLDINGS INC,0
003A,14589,ADAMAS PHARMACEUTICALS INC,0
003D,14500,BLUEROCK RESIDENTIAL GR REIT IN,0
003E,14566,FARMLAND PARTNERS INC,0
003F,14612,TRIVASCULAR TECHNOLOGIES INC,0
003G,14615,VITAL THERAPIES INC,0
003H,14579,PAYCOM SOFTWARE INC,0
003J,14559,CITY OFFICE REIT INC,0
003K,14603,PHIBRO ANIMAL HEALTH CORP,0
0040,14595,LOMBARD MEDICAL INC,0
0041,14608,SABRE CORP,0
0042,14642,DORIAN L P G LTD,0
0044,14669,SUNEDISON SEMICONDUCTOR LIMITED,0
0045,14634,PARSLEY ENERGY INC,0
004F,14617,ARES MANAGEMENT LP,0
004M,14618,CHEETAH MOBILE INC,0
004V,14676,TUNIU CORP,0
004W,14714,ARISTA NETWORKS INC,0
0051,14641,ZENDESK INC,0
0055,14677,TRUECAR INC,0
005H,14625,HERITAGE INSURANCE HOLDINGS INC,0
005I,14645,AGILE THERAPEUTICS INC,0
006J,14697,MOBILEIRON INC,0
006K,14687,ATLANTICA YIELD PLC,0
006M,14715,ASPEN AEROGELS INC,0
006Q,14756,NORDIC AMERICAN OFFSHORE LTD,0
006V,14706,PARNELL PHARMACEUTICALS HLDG LT,0
006W,14716,CENTURY COMMUNITIES INC,0
006X,14694,GOPRO INC,0
0070,14707,RADIUS HEALTH INC,0
0073,14754,T C P INTERNATIONAL HOLDINGS LT,0
0074,14713,ADEPTUS HEALTH INC,0
0075,14688,AMPHASTAR PHARMACEUTICALS INC,0
0076,14705,MATERIALISE NV,0
0077,14710,XUNLEI LTD,0
0079,14734,NEXTERA ENERGY PARTNERS LP,0
007W,12961,PINGTAN MARINE ENTERPRISE LTD,0
007X,14750,SERVICEMASTER GLOBAL HOLDINGS I,0
0080,14784,PARAGON OFFSHORE PLC,0
008A,14828,SAGE THERAPEUTICS INC,0
008C,14856,MOBILEYE N V,0
008I,14424,AKARI THERAPEUTICS PLC,0
008J,14778,TOWNSQUARE MEDIA INC,0
008U,14786,ORION ENGINEERED CARBONS SA,0
008Y,13038,BURCON NUTRASCIENCE CORP,0
0090,14851,F C B FINANCIAL HOLDINGS INC,0
0097,14870,GREEN BANCORP INC,0
0098,14759,ADVANCED DRAINAGE SYSTEMS INC,0
009H,14849,C 1 FINANCIAL INC,0
009J,14874,OTONOMY INC,0
00A5,14689,AEMETIS INC,0
00AI,14556,ENERGOUS CORP,0
00AO,14983,WAYFAIR INC,0
00AP,15113,RESTAURANT BRANDS INTL INC,0
00AW,14708,SIGNAL GENETICS INC,0
00B1,14937,TOKAI PHARMACEUTICALS INC,0
00BG,14928,CYBERARK SOFTWARE LTD,0
00BV,14945,A A C HOLDINGS INC,0
00BW,14995,CALITHERA BIOSCIENCES INC,0
00BX,14961,FAIRMOUNT SANTROL HOLDINGS INC,0
00BY,15003,DERMIRA INC,0
00C5,14915,SMART & FINAL STORES INC,0
00C6,14939,KEYSIGHT TECHNOLOGIES INC,0
00C9,15014,DAVE & BUSTERS ENTERTAINMENT IN,0
00CB,14956,DOMINION MIDSTREAM PARTNERS LP,0
00CC,14942,KIMBALL ELECTRONICS INC,0
00CL,15059,COHERUS BIOSCIENCES INC,0
00D3,14960,ENOVA INTERNATIONAL INC,0
00D4,14974,NEW SENIOR INVESTMENT GROUP INC,0
00DA,15008,FIFTH STREET ASSET MANAGEMENT,0
;;;;
data dataset2;
infile datalines dsd truncover;
input ticker:$6. companyid:32. comname:$31. score:32.;
datalines4;
0000,14471,TALMER BANCORP INC,0
0001,14392,E P ENERGY CORP,0
0004,14418,AMERICAN CAPITAL SR FLOATING LT,0
000R,14378,CARE COM INC,0
000V,14423,EIGER BIOPHARMACEUTICALS INC,0
000Y,14436,ULTRAGENYX PHARMACEUTICALS INC,0
000Z,14449,BIOCEPT INC,0
0011,14416,C H C GROUP LTD,0
0017,14448,AUSPEX PHARMACEUTICALS INC,0
0018,14455,EGALET CORP,0
001A,14452,ELEVEN BIOTHERAPEUTICS INC,0
001C,14447,ARGOS THERAPEUTICS INC,2
001J,14487,KNOWLES CORP,0
001K,14479,INSTALLED BUILDING PRODUCTS INC,0
001L,14451,CONCERT PHARMACEUTICALS INC,0
001M,14459,INOGEN INC,0
001N,14504,QUOTIENT TECHNOLOGY INC,0
001R,12962,C S R PLC,0
001X,14550,RECRO PHARMA INC,0
001Z,14524,KING DIGITAL ENTERTAINMENT PLC,0
002G,14502,CASTLIGHT HEALTH INC,0
002J,14547,PAYLOCITY HOLDING CORP,0
002L,14499,AMBER ROAD INC,0
002P,14495,A10 NETWORKS INC,0
002S,14574,MOELIS & CO,0
002T,14503,OUTFRONT MEDIA INC,0
002U,14616,WEIBO CORP,0
002Y,14527,NORD ANGLIA EDUCATION INC,0
0031,14594,CORIUM INTERNATIONAL INC,0
0033,14578,OPOWER INC,0
0039,14573,LA QUINTA HOLDINGS INC,0
003A,14589,ADAMAS PHARMACEUTICALS INC,0
003D,14500,BLUEROCK RESIDENTIAL GR REIT IN,0
003E,14566,FARMLAND PARTNERS INC,0
003F,14612,TRIVASCULAR TECHNOLOGIES INC,0
003G,14615,VITAL THERAPIES INC,0
003H,14579,PAYCOM SOFTWARE INC,0
003J,14559,CITY OFFICE REIT INC,0
003K,14603,PHIBRO ANIMAL HEALTH CORP,0
0040,14595,LOMBARD MEDICAL INC,0
0041,14608,SABRE CORP,0
0042,14642,DORIAN L P G LTD,0
0044,14669,SUNEDISON SEMICONDUCTOR LIMITED,0
0045,14634,PARSLEY ENERGY INC,0
004F,14617,ARES MANAGEMENT LP,0
004M,14618,CHEETAH MOBILE INC,0
004V,14676,TUNIU CORP,0
004W,14714,ARISTA NETWORKS INC,0
0051,14641,ZENDESK INC,0
0055,14677,TRUECAR INC,0
005H,14625,HERITAGE INSURANCE HOLDINGS INC,0
005I,14645,AGILE THERAPEUTICS INC,0
006J,14697,MOBILEIRON INC,0
006K,14687,ATLANTICA YIELD PLC,0
006M,14715,ASPEN AEROGELS INC,0
006Q,14756,NORDIC AMERICAN OFFSHORE LTD,0
006V,14706,PARNELL PHARMACEUTICALS HLDG LT,0
006W,14716,CENTURY COMMUNITIES INC,0
006X,14694,GOPRO INC,0
0070,14707,RADIUS HEALTH INC,0
0073,14754,T C P INTERNATIONAL HOLDINGS LT,0
0074,14713,ADEPTUS HEALTH INC,0
0075,14688,AMPHASTAR PHARMACEUTICALS INC,0
0076,14705,MATERIALISE NV,0
0077,14710,XUNLEI LTD,0
0079,14734,NEXTERA ENERGY PARTNERS LP,0
007W,12961,PINGTAN MARINE ENTERPRISE LTD,0
007X,14750,SERVICEMASTER GLOBAL HOLDINGS I,0
0080,14784,PARAGON OFFSHORE PLC,0
008A,14828,SAGE THERAPEUTICS INC,0
008C,14856,MOBILEYE N V,0
008I,14424,AKARI THERAPEUTICS PLC,0
008J,14778,TOWNSQUARE MEDIA INC,0
008U,14786,ORION ENGINEERED CARBONS SA,0
0090,14851,F C B FINANCIAL HOLDINGS INC,0
0097,14870,GREEN BANCORP INC,0
0098,14759,ADVANCED DRAINAGE SYSTEMS INC,0
009H,14849,C 1 FINANCIAL INC,0
009J,14874,OTONOMY INC,0
00A5,14689,AEMETIS INC,0
00AI,14556,ENERGOUS CORP,0
00AO,14983,WAYFAIR INC,0
00AW,14708,MIRAGEN THERAPEUTICS INC,0
00B1,14937,NOVUS THERAPEUTICS INC,0
00BG,14928,CYBERARK SOFTWARE LTD,0
00BV,14945,A A C HOLDINGS INC,0
00BW,14995,CALITHERA BIOSCIENCES INC,0
00BX,14961,FAIRMOUNT SANTROL HOLDINGS INC,0
00BY,15003,DERMIRA INC,0
00C5,14915,SMART & FINAL STORES INC,0
00C6,14939,KEYSIGHT TECHNOLOGIES INC,0
00C9,15014,DAVE & BUSTERS ENTERTAINMENT IN,0
00CB,14956,DOMINION ENERGY MIDSTREAM PTN L,0
00CC,14942,KIMBALL ELECTRONICS INC,0
00CL,15059,COHERUS BIOSCIENCES INC,0
00D3,14960,ENOVA INTERNATIONAL INC,0
00D4,14974,NEW SENIOR INVESTMENT GROUP INC,0
00DA,15008,FIFTH STREET ASSET MANAGEMENT,0
00DB,14953,BOOT BARN HOLDINGS INC,0
00DD,15083,STATE NATIONAL COMPANIES INC,0
;;;;
Click image to register for webinar
