Does SAS EG have an operator similar to LIKE that works on numeric instead of characters. Like this statement:
WHERE t1.REGNSKKD_R LIKE '302%';
CodePudding user response:
Assuming that the column REGNSKKD_R has a fixed length of 8 digits then the numeric solution to your problem is the following:
WHERE t1.REGNSKKD_R between 30200000 and 30299999