Hello @agrocrag14,   REGEXP_SUBSTR is an Oracle function, as is explained in this paper. So, you can use it in queries against an Oracle database using the PROC SQL Pass-Through facility, but it is not applicable to SAS datasets. Use PRX functions instead (see references in the paper or the documentation).   ... View more

What would a full join look like? It looks like a match merge is getting me close to what I need to accomplish but I need a combo of the two variables as a key value can appear more than once (belong to 2 list_names). ... View more