topic Re: SAS Function to to identify orders ending with 01 in SAS Programming

SAS Function to to identify orders ending with 01

avatar — Fri, 24 May 2019 16:42:08 GMT

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

Thanks

Re: SAS Function to to identify orders ending with 01

Amir — Fri, 24 May 2019 16:47:23 GMT

Please provide some context, for example:

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

Amir.

Re: SAS Function to to identify orders ending with 01

PaigeMiller — Fri, 24 May 2019 16:48:13 GMT

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';

Re: SAS Function to to identify orders ending with 01

avatar — Fri, 24 May 2019 16:51:13 GMT

it is character data

585452101
571629201
585175701
24968566
579876301
575507505
184126254
184021353
577099102

Re: SAS Function to to identify orders ending with 01

novinosrin — Fri, 24 May 2019 16:51:14 GMT

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

Re: SAS Function to to identify orders ending with 01

novinosrin — Fri, 24 May 2019 16:53:37 GMT


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;

Re: SAS Function to to identify orders ending with 01

Amir — Fri, 24 May 2019 17:04:06 GMT

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.