SAS Function to to identify orders ending with 01

[avatar]

I would lik eto know whaich sas function to use to get all orders ending with 01. Please reply

Thanks

[Amir]

Please provide some context, for example:

1. Is the data character or numeric?
2. Will there ever be decimal numbers?
3. If decimal, should the decimal be portion be ignored or used?
4. Please provide some data in the form of a data step using datalines showing before and after the function is applied.

Amir.

[avatar]

it is character data 

585452101
571629201
585175701
24968566
579876301
575507505
184126254
184021353
577099102

[Amir]

Thank you. You could try:

data have;
   input order_num $10.;
   datalines;
585452101
571629201
585175701
24968566
579876301
575507505
184126254
184021353
577099102
;

data want;
   set have;

   if left(reverse(order_num)) =: '10';
run;

Amir.

[PaigeMiller]

Let's suppose the order number is in a character variable named ORDER_NUM. Then in a SAS data step

if reverse(trim(order_num))=:'10';

[novinosrin · Accepted solution]

if substr(var,length(var)-1,2)='01'; 

[novinosrin]

data have;
input var $20.;
cards;
585452101
571629201
585175701
24968566
579876301
575507505
184126254
184021353
577099102
;

data want;
set have;
if substr(var,length(var)-1,2)='01';
run;

/*or indentify/flag*/

data want;
set have;
if substr(var,length(var)-1,2)='01' then flag=1;
run;