Thank you for your help!
However I still face the same problem that it is not well sorted.
For instance, I have the following result:
But in #12, this observation is supposed to be matched with
I have tried to find the code that makes this result, but it is not working..
However I still face the same problem that it is not well sorted.
For instance, I have the following result:
Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input int org_nid str159 org_name_m int uni_id str107 uni_name_m double similscore long max_sim
1 "CALIFORNIA STATE UNIVERSITY FRESNO FOUNDATION" 1580 "NORTHEASTERN UNIVERSITY" .5 125
2 "501 BOARD OF REGENTS, UNIV. OF TEXAS" 2038 "SOUTH DAKOTA BOARD OF REGENTS" .5607672692959075 128
14 "501 REGENTS OF UNIVERSITY OF MINNESOTA" 1393 "MINNESOTA STATE UNIVERSITY, MOORHEAD" .5014122105639002 461
20 "501 REGENTS OF THE UNIVERSITY OF CALIFORNIA" 2741 "WILLIAM CAREY UNIVERSITY" .5013026509266503 713
32 "ADELPHI UNIVERSITY" 2373 "UNIVERSITY LYNCHBURG" .5007733956671915 1519
36 "ALABAMA A&M UNIVERSITY" 2081 "SOUTHERN UNIVERSITY AND A&M COLLEGE, SYSTEM OFFICE" .5002164033860247 1816
40 "ALBANY COLLEGE OF PHARMACY" 1289 "MARYGROVE COLLEGE" .5 1976
42 "ALBANY MEDICAL COLLEGE" 2079 "SOUTHERN TECHNICAL COLLEGE" .5004345937369794 2130
43 "ALBANY MEDICAL COLLEGE OF UNION UNIVERSITY" 1055 "JEFFERSON STATE COMMUNITY COLLEGE" .5 2285
50 "ALBERT EINSTEIN COLLEGE OF MEDICINE OF YESHIVA UNIVERSITY" 1396 "MINOT STATE UNIVERSITY" .5006261743217589 2628
58 "ALBERT EINSTEIN COLLEGE OF MEDICINE OF YESHIVA UNIVERSITY, A DIVISION OF YESHIVA" 721 "EDWARD VIA COLLEGE OF OSTEOPATHIC MEDICINE" .5036459795058438 2796
67 "ALBERT EINSTEIN HEALTHCARE NETWORK" 29 "ALBERT EINSTEIN COLLEGE OF MEDICINE" .5929994533288809 2853
71 "ALFRED E. MANN INSTITUTE FOR BIOMEDICAL ENGINEERING AT THE UNIVERSITY OF SOUTHERN CALIFORNIA" 2616 "VIRGINIA POLYTECHNIC INSTITUTE AND STATE UNIVERSITY" .5003648304024271 3009
80 "ALFRED UNIVERISTY" 345 "CALIFORNIA STATE UNIVERSITY, FRESNO" .5 3645
85 "ALFRED UNIVERSITY" 877 "GRAMBLING STATE UNIVERSITY" .5 4025
102 "ALFRED UNIVERSITY RESEARCH FOUNDATION, INC." 67 "ANDREWS UNIVERSITY" .5006389778965061 5303
103 "ALL AMERICAN UNIVERSITY, INCORPORATED" 347 "CALIFORNIA STATE UNIVERSITY, LONG BEACH" .5 5405
112 "ALLEGHENY UNIVERSITY OF THE HEALTH SCIENCES" 2776 "YALE UNIVERSITY" .5 6269
124 "ALVERNO COLLEGE" 275 "COLLEGE WOOSTER" .5 7133
130 "AMBASSADOR COLLEGE" 1245 "MACALESTER COLLEGE" .5007733956671915 7596
154 "AMERICAN COLLOID COMPANY" 1442 "MORGAN COMMUNITY COLLEGE" .5003191829243043 8324
159 "AMERICAN TECHNOLOGICAL UNIVERSITY" 2096 "SOUTHWESTERN CHRISTIAN UNIVERSITY" .5 8574
161 "AMERICAN TYPE CULTURE COLLECTION" 1967 "SAN MATEO COUNTY COMMUNITY COLLEGE DISTRICT, CANADA COLLEGE" .5042150376900755 8673
163 "APPALACHAIN STATE UNIVERSITY" 2084 "SOUTHERN UTAH UNIVERSITY" .5003191829243043 8823
167 "APPALACHIAN STATE UNIVERSITY" 2084 "SOUTHERN UTAH UNIVERSITY" .5003191829243043 9397
176 "ARIZONA BOARD OF REGENTS" 406 "CENTRAL ARIZONA COLLEGE" .511681719253465 10038
180 "ARIZONA BOARD OF REGENTS ACTING ON BEHALF OF ARIZONA STATE UNIVERSITY" 2200 "TENNESSEE BOARD OF REGENTS" .5 10073
186 "ARIZONA BOARD OF REGENTS OF ARIZONA STATE UNIVERSITY" 1424 "MONTANA STATE UNIVERSITY, BOZEMAN" .5003702332976756 10161
194 "ARIZONA BOARD OF REGENTS, THE UNIVERSITY OF ARIZONA" 2552 "UNIVERSITY OF THE DISTRICT OF COLUMBIA" .5032196082827126 10296
199 "ARIZONA BOARD OF REGENTS, A BODY CORPORATE OF THE STATE OF ARIZONA, ACTING FOR AND ON BEHALF OF THE ARIZONA STATE UNIVERSITY" 1290 "MARYLAND INSTITUTE COLLEGE OF ART" .5008923797926393 10411
204 "ARTHUR A. COLLINS, INC." 276 "COLLEGE OF COURT REPORTING INC." .5103103630798288 10416
207 "ASSOCIATED UNIVERSITIES, INC." 2699 "WESTERN ILLINOIS UNIVERSITY" .5 10506
221 "AUBURN UNIVERSITY" 751 "EVEREST UNIVERSITY, POMPANO BEACH" .5 11526
224 "BALL STATE UNIVERSITY" 2372 "UNIVERSITY LOUISVILLE" .5 12096
242 "BAYLOR COLLEGE OF MEDICINE" 276 "COLLEGE OF COURT REPORTING INC." .5 13292
255 "BAYLOR RESEARCH INSTITUTE" 2066 "SOUTHERN CALIFORNIA INSTITUTE OF ARCHITECTURE" .5 13739
272 "BIOCOLL LABORATORIES, INC." 508 "COLD SPRING HARBOR LABORATORY" .5773502691896257 13805
280 "BIOMM, INC. & UNIVERSITY OF MIAMI" 2619 "VIRGINIA UNION UNIVERSITY" .5 13917
281 "BOARD OF CONTROL OF MICHIGAN TECHNOLOGICAL UNIVERSITY" 2160 "STATE UNIVERSITY SYSTEM OF FLORIDA BOARD OF GOVERNORS" .5002164033860247 13954
282 "BOARD OF CONTROL OF MICHIGAN TECHNOLOGY UNIVERSITY" 675 "DREXEL UNIVERSITY, COLLEGE OF MEDICINE AND COLLEGE OF NURSING AND HEALTH PROFESSIONS" .5004849504874057 13992
288 "BOARD OF GOVERNORS OF WAYNE STATE UNIVERSITY AND VANDERBILT UNIVERSITY" 2262 "TRINITY WASHINGTON UNIVERSITY" .5 15468
289 "BOARD OF OVERSEERS OF GOSHEN COLLEGE" 2552 "UNIVERSITY OF THE DISTRICT OF COLUMBIA" .5010667310928439 15479
309 "BOARD OF REAGENTS, THE UNIVERSITY OF TEXAS SYSTEM" 2059 "SOUTHEASTERN OKLAHOMA STATE UNIVERSITY" .5006010821645458 16191
312 "BOARD OF REGENIS, THE UNIVERSITY OF TEXAS SYSTEM" 2200 "TENNESSEE BOARD OF REGENTS" .5010973520018859 16380
318 "BOARD OF REGENTS FOR EDUCATION OF THE STATE OF RHODE ISLAND" 295 "COLLEGE OF THE MUSCOGEE NATION" .5007448238897287 16523
319 "BOARD OF REGENTS FOR OKLAHOMA AGRICULTURAL & MECHANICAL COLLEGES ACTING FOR OKLA" 1905 "SAINT FRANCIS MEDICAL CENTER COLLEGE OF NURSING" .5087725990284107 16526
320 "BOARD OF REGENTS FOR THE UNIVERSITY OF OK" 2556 "UNIVERSITY OF THE SCIENCES PHILADELPHIA" .5019011475427825 16567
328 "BOARD OF REGENTS OF THE UNIVERSITY OF THE UNIVERSITY OF WISCONSIN SYSTEM, ON BEH" 2526 "UNIVERSITY WISCONSIN-PARKSIDE" .5000913325425463 17160
331 "BOARD OF REGENTS OF THE UNIV OF NE AT LINCOLN" 283 "COLLEGE OF SAINT ELIZABETH" .5 17380
338 "BOARD OF REGENTS OF THE UNIVERSITY WASHINGTON" 2566 "UNIFORMED SERVICES UNIVERSITY OF THE HEALTH SCIENCES" .5010436868371889 17688
343 "BOARD OF REGENTS OF THE UNIVERSITY AND COMMUNITY COLLEGE SYSTEMS OF NEVADA" 2566 "UNIFORMED SERVICES UNIVERSITY OF THE HEALTH SCIENCES" .5012638148421292 18072
344 "BOARD OF REGENTS OF THE UNIVERSITY OF NEBRASKA" 2535 "UNIVERSITY OF HOLY CROSS" .5039526306789697 18108
345 "BOARD OF REGENTS OF THE UNIVERSITY OF TEXAS" 1982 "SCHOOL OF THE ART INSTITUTE OF CHICAGO" .5001715560180865 18150
356 "BOARD OF REGENTS OF THE UNIVERSITY OF WISCONSIN SYSTEM ON BEHALF OF UNIVERSITY O" 2530 "UNIVERSITY WISCONSIN-STOUT" .5003788904467943 18852
359 "BOARD OF REGENTS OF THE UNIVERSITY OF WISCONSIN SYSTEM ON BEHALF OF THE UNIVERSI" 2381 "UNIVERSITY MAINE, SYSTEM OFFICE" .5005109863367264 19058
365 "BOARD OF REGENTS, THE UNIVERSITY OF" 2556 "UNIVERSITY OF THE SCIENCES PHILADELPHIA" .5006261743217589 19400
367 "BOARD OF REGENTS, THE UNIVERSITY OF TEXAS" 296 "COLLEGE OF THE OUACHITAS" .5 19498
383 "BOARD OF REGENTS, THE UNIVERSITY OF TEXAS SYSTEM" 2459 "UNIVERSITY PUERTO RICO, SYSTEM OFFICE" .5026246899500346 20289
388 "BOARD OF REGENTS, UNIVERSITY OF NEBRASKA-LINCOLN" 2311 "UNIVERSITY CALIFORNIA, OFFICE OF THE PRESIDENT" .5000857559392293 20488
389 "BOARD OF REPORTS, THE UNIVERSITY OF TEXAS SYSTEM" 2714 "WESTERN UNIVERSITY OF HEALTH SCIENCES" .5026246899500346 20536
394 "BOARD OF SUPERVISORS OF LOUISIANA STATE UNIVERSITY AND AGRICULTURAL & MECHANICAL COLLEGE" 878 "GRAND CANYON UNIVERSITY" .5010319928420137 20796
401 "BOARD OF TRUSTEES OPERATING MICHIGAN STATE UNIVERSITY" 1842 "RUTGERS, STATE UNIVERSITY NEW JERSEY" .5001715560180865 21496
402 "BOARD OF TRUSTEES WESTERN WASHINGTON STATE COLLEGE" 2579 "UNIVERSITIES AND STATE COLLEGES OF ARIZONA, ALL CAMPUSES" .500459817192153 21545
403 "BOARD OF TRUSTEES OF MICHIGAN STATE UNIVERSITY" 1818 "ROCHESTER UNIVERSITY" .5002164033860247 21627
405 "BOARD OF TRUSTEES OF MICHIGAN UNIVERSITY" 443 "CHARLES R. DREW UNIVERSITY OF MEDICINE AND SCIENCE" .5009794328681195 21739
408 "BOARD OF TRUSTEES OF SOUTHERN ILLINOIS UNIVERSITY" 1613 "NORTHWESTERN OKLAHOMA STATE UNIVERSITY" .5006010821645458 21931
414 "BOARD OF TRUSTEES OF THE LELANE STANDARD JUNIOR UNIVERSITY" 975 "HOWARD UNIVERSITY" .5 22265
422 "BOARD OF TRUSTEES OF WESTERN ILLINOIS UNIVERSITY" 2547 "UNIVERSITY OF ST. THOMAS (MN)" .5 22697
430 "BOARD OF TRUSTEES OF THE LELAND STANFORD JR. UNIVERSITY" 2558 "UNIVERSITY OF THE VIRGIN ISLANDS" .5010886143955939 22931
447 "BOARD OF TRUSTEES OF THE UNIVERSITY OF ILLINOIS" 2487 "UNIVERSITY TENNESSEE, KNOXVILLE, INSTITUTE OF AGRICULTURE" .5 23518
451 "BOARD OF TRUSTEES OF THE UNIVERSITY OF ILLINOIS-URBANA" 2711 "WESTERN STATE UNIVERSITY COLLEGE OF LAW" .5004464951031116 23674
466 "BOARD OF TRUSTEES OF THE UNIVERSITY OF MAINE" 860 "GLOBE UNIVERSITY, MINNESOTA SCHOOL OF BUSINESS" .5018683272627928 24188
467 "BOARD OF TRUSTEES OF THE WICHITA STATE UNIVERSITY" 1621 "NOTRE DAME OF MARYLAND UNIVERSITY" .5066403971048989 24280
474 "BOARD OF TRUSTEES, UNIV. OF TX SYS." 2160 "STATE UNIVERSITY SYSTEM OF FLORIDA BOARD OF GOVERNORS" .5163977794943223 24857
476 "BOARD OF TRUSTESS OPERATING MICHIGAN STATE UNIVERSITY" 1842 "RUTGERS, STATE UNIVERSITY NEW JERSEY" .5001715560180865 25059
479 "BOISE STATE UNIVERSITY" 2657 "WAYLAND BAPTIST UNIVERSITY" .5004345937369794 25474
496 "BOSTON COLLEGE" 2178 "SULLIVAN COUNTY COMMUNITY COLLEGE" .5 28071
498 "BOSTON UNIVERSITY RESEARCH FOUNDATION" 2760 "WISCONSIN STATE UNIVERSITY ALL CAMPUSES" .5 28278
505 "BOWIE STATE UNIVERSITY" 2400 "UNIVERSITY MISSOURI SYSTEM" .5004345937369794 28849
508 "BOWLING GREEN STATE UNIVERSITY" 2248 "TREVECCA NAZARENE UNIVERSITY" .5002780094738025 29274
516 "BRANDEIS UNIVERSITY" 238 "BRIGHAM YOUNG UNIVERSITY, PROVO" .5 29994
527 "BRIGHAM YOUNG UNIVERSITY" 2404 "UNIVERSITY MOBILE" .5 30709
538 "BRIGHAM YOUNG UNIVERSITY TECHNOLOGY TRANSFER OFFICE" 2691 "WEST VIRGINIA UNIVERSITY, INSTITUTE OF TECHNOLOGY" .5 31238
543 "BROOKLYN COLLEGE RESEARCH AND DEVELOPMENT FOUNDATION" 1435 "MOORE COLLEGE OF ART AND DESIGN" .5182571321747 31248
550 "BROWN UNIVERSITY RESEARCH FOUNDATION" 1513 "NEW JERSEY CITY UNIVERSITY" .5001930129390556 31584
555 "BRYN MAWR COLLEGE" 1659 "OLYMPIC COLLEGE" .5 31830
562 "BUTLER UNIVERSITY" 2644 "WASHINGTON ADVENTIST UNIVERSITY" .5 32277
569 "CA. STATE UNIVERSITY, LONG BEACH FOUNDATION" 2120 "ST. BONAVENTURE UNIVERSITY" .5 33008
573 "CP HAHNEMANN UNIVERSITY" 2033 "SONOMA STATE UNIVERSITY" .5 33363
587 "CALIFORNIA INSTITUTE OF TECHNOLOGY" 1791 "RENSSELAER POLYTECHNIC INSTITUTE, TROY" .5015654934810319 33717
619 "CALIFORNIA STATE UNIVERSITY, FRESNO FOUNDATION" 792 "FONTBONNE UNIVERSITY" .5002164033860247 35429
626 "CALIFORNIA STATE UNIVERSITY-FULLERTON" 1611 "NORTHWESTERN HEALTH SCIENCES UNIVERSITY" .500567859353936 36564
630 "CALVIN COLLEGE" 2646 "WASHINGTON COUNTY COMMUNITY COLLEGE" .5 37072
650 "CAMBRIDGE COLLABORATIVE, INC." 1137 "LAMAR STATE COLLEGE, ORANGE" .5 38992
670 "CARGENIE MELLON UNIVERSITY" 2084 "SOUTHERN UTAH UNIVERSITY" .5003191829243043 40492
679 "CARNEGIE MELLON UNIVERSITY" 1167 "LEHIGH UNIVERSITY" .5 41212
695 "CASE WESTERN RESERVE UNIVERSITY" 2692 "WEST VIRGINIA UNIVERSITY, PARKERSBURG" .5 42822
709 "CENTRAL MICHIGAN UNIVERSITY BOARD OF TRUSTEES" 1974 "SANTA FE UNIVERSITY OF ART AND DESIGN" .5005173307126191 44521
717 "CHAPMAN COLLEGE" 324 "CABRINI COLLEGE" .5 45337
719 "CLARK UNIVERSITY" 340 "CALIFORNIA STATE UNIVERSITY, BAKERSFIELD" .5003702332976756 45538
end
Code:
-> org_id = 1, org_name_m = CALIFORNIA STATE UNIVERSITY FRESNO FOU.. similscore uni_name_m 1. .8618575 CALIFORNIA STATE UNIVERSITY, FRESNO 2. .7438395 CALIFORNIA STATE UNIVERSITY, FULLERTON 3. .72231512 CALIFORNIA STATE UNIVERSITY, MONTEREY BAY 4. .71306774 CALIFORNIA STATE UNIVERSITY, CHICO 5. .69751845 CONSORTIUM OF CALIFORNIA STATE UNIVERSITY 6. .69282032 CALIFORNIA STATE UNIVERSITY, STANISLAUS 7. .62387947 UNIVERSITY CALIFORNIA, COOPERATIVE EXTENSION ------------------------------------------------------------------------------------------------------------------------------------------------------------------
Comment