Searching and replacing characters

[archita]

hi,

title'silver-level customers';
proc print data=silver;
run;

In this code, I am creating three datasets namely silver, gold and platinum based on the customer_id values. I also need to modify any four digit string in customer_id  by -15- instead of -00-, the searches are case insensitive.I am not getting the results please help. for e.g customer _id- platinum000-000-00-0010,Silver000-000-00-0024 etc. thanks in advance.

[PaigeMiller]

Show us a portion of the data before this change, and after.

[archita]

Hi,

Below is the input data

I want it to be -15- in place of -00- , in case of all 4digit  string in customer_id.

[PaigeMiller]

UNTESTED CODE

data want;
    set have;
    customer_id=tranwrd(customer_id,'-00-,'-15-');
run;

The usual advice here is that we can't write code to test against screen captures of your data. The proper way to provide data from now on is as SAS data step code, which you can type yourself, or use these instructions. So from now on, please provide the data as requested.

[archita]

Hi,

The code provided is not working .

My code is;

data silver gold platinum;
set blib.customers_ex5;
customer_id=propcase(customer_id);
if customer_id = 'Silver' then output silver;
if customer_id = 'Gold' then output gold;
if customer_id = 'Platinum' then output platinum;
customer_id = tranwrd(customer_id,'-00-','-15-');
run;
title 'silver-level customers';
proc print data=silver;
run;
title'gold-level customers';
proc print data=silver;
run;
title'platinum-level customers';
proc print data=platinum;
run;

[Tom · Accepted solution]

Changing the value of CUSTOMER_ID after the observation has already been written is not going to have any impact.

Move the assignment statement before the IF statements that conditionally write the data.

Your IF statements are not going to write any of the observations that had the string '-00-' in them.

Do you want to test if the START of the value is Silver?

Use the colon modifier on the comparison operator.

customer_id=propcase(tranwrd(customer_id,'-00-','-15-'));
if customer_id =: 'Silver' then output silver;
if customer_id =: 'Gold' then output gold;
if customer_id =: 'Platinum' then output platinum;

[archita]

Thank you, working now.

[PaigeMiller]

Hello @archita 

As requested above, it is not sufficient to say it is not working, and provide no other details. If there are errors in the log, then SHOW US the entire log for the step which isn't working (instructions for providing the log already provided, please follow them). If the output is wrong, then SHOW US what output you get, and what you want to get.

[archita]

Thanks , point noted.