data blah;
input refid $40.;
cards;
000-ABCD
0A0-ABCD
;
data want;
set blah;
if prxmatch('/\d{3}-[A-Z]{4}/', refid);
run;
SAS Innovate 2025: Register Now
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9. Sign up by Dec. 31 to get the 2024 rate of just $495. Register now!
How to Concatenate Values
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.