topic Re: Join Tables on Variables using a Begin With or Like Function in SAS Enterprise Guide

Join Tables on Variables using a Begin With or Like Function

capuanjm — Thu, 13 Oct 2016 15:38:01 GMT

I have a set of diagnosis codes that were provided with an X variable, where the X represents some numeric value. Ex. 410.0x. The x can be a 1 or 2. I want to join two tables 1) has the 410.0x and the 2) has the 410.01 and 410.02. How do I link the tables on the variable that allows for a Begins with '410.0' and returns the 410.01 and 410.02

Re: Join Tables on Variables using a Begin With or Like Function

skg74_mail_umkc_edu — Thu, 13 Oct 2016 15:45:47 GMT

Do you have common variable for merging two datasets or tables other than Diagnostic codes?

Re: Join Tables on Variables using a Begin With or Like Function

Reeza — Thu, 13 Oct 2016 15:56:47 GMT

When you join you can include functions in the join. So substr the variable if you want only the first 5 digits to match

Re: Join Tables on Variables using a Begin With or Like Function

capuanjm — Thu, 13 Oct 2016 17:05:17 GMT

No. The second table is a dimension tables to serve as a lookup.

Re: Join Tables on Variables using a Begin With or Like Function

PGStats — Thu, 13 Oct 2016 18:21:32 GMT

You could join on the condition:

translate(code1, "1", "x") = code2 OR translate(code1, "2", "x") = code2