Home > front end >  SAS EG LIKE operator on numeric value
SAS EG LIKE operator on numeric value

Time:11-01

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
  • Related