Struggling with Table Lookup in SAS

[hashman]

@ChrisNZ:

Well, it's good to have someone's terseness balance another's verbosity ;).

Have a nice weekend, too! 

[ChrisNZ]

>But my results end up looking like a concatenation

that probably means the keys have different values.

>  I changed the Primary and DSC_25 variables into a 6-length character string variable named mergevariable (previously one was a numeric, and the other was a character

Maybe the conversion has issue? Are the converted numbers left-aligned?

[Shmuel]

I had a typo in the first method, the code should be:

proc sort data=sth_icd10; by primary; run;
proc sort data=reftable_merge; by cde_diag; run;

data all;
merge sth_icd10 
      reftable_merge (rename = (cde_diag = primary));
by primary;
      /*  drop mergevariable; << no need */
run;