04-24-2017 09:14 AM
I would like to know why my created index is not matching against entries, and how to do it correctly i guess:
example below should match the Match this Value from the MATCH Dataset, but it comes back with a blank value.
input first $char80. second $char80.;
input name $char80.;
proc datasets library=dan ;
modify test_data1 ;
index create match_name=(first second);
SET dan.test_data1 KEY=match_name / UNIQUE;
In the reall world i have 1000 names that i would like to match against a dataset of 1 million rows , creating an index on first and second name - but my results are coming back blank, using effectively the same logic as above.
Any help is greatly appreicated
04-24-2017 11:00 AM
Were you able to successfully join the datasets without the index? Is it just that you have been successful at joining the datasets but would like to speed up the process, or that you have not joined them yet and will do so using index?
It may be expedient and clearer for you to split the combined first/last name cell in match.name into separate cells. Then, create your index on the first/last name columns.