I agree that this identifier is sub-optimal, but unfortunately I need to do a datamatch with a database that only has this identifier available. One quick follow-up question: How do I remove the slashes from the identifier? I am currently using this code: data match.mydatabase3; set match.mydatabase3; length URN $100; URN=upcase(cats(substr(first_name,1,1),substr(first_name,3,1),substr(last_name,1,1),substr(last_name,3,1),put(dob,MMDDYY8.),put(Gender_forTLCmatch,1.),"U")); run; Which produces this: SRSI09/01/992U Instead of this (which is what I want): SRSI0901992U Thanks very much.
... View more