Hi!   I am working with two tables that have missing values for IDs. I am doing an outer join for the two tables. I want to make sure rows are only joined if the IDs are NOT null. I still would like these printed, just not joined. Can I do this in one SQL step? Example: if I join these tables: ID Amount 123 45   48   24   ID Tax 123 23   4   I want this output: ID Amount Tax 123 45 23   48 .   24 .   . 4 ... View more

Hi!   I am trying to use a regular expression in the DATA step to check that a value is EXACTLY 9 digits.    patternNoDash=prxparse("/^(\d){9}$/");    Another valid pattern is 11 digits long, so the variable has a length of 11. With the anchor characters, this seems to be messing me up(?) I am using ID= strip(ID) to remove all of the outer whitespace but the pattern will still not match with the anchor characters. Am I missing something obvious? I don't have to use regex but I am     ... View more