topic Re: Searching and replacing characters in New SAS User

Searching and replacing characters

archita — Fri, 29 Apr 2022 15:29:38 GMT

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.

Re: Searching and replacing characters

PaigeMiller — Fri, 29 Apr 2022 15:35:05 GMT

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

Re: Searching and replacing characters

archita — Fri, 29 Apr 2022 16:18:26 GMT

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.

Re: Searching and replacing characters

PaigeMiller — Fri, 29 Apr 2022 17:22:31 GMT

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.

Re: Searching and replacing characters

archita — Sat, 30 Apr 2022 12:58:40 GMT

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;

Re: Searching and replacing characters

Tom — Sat, 30 Apr 2022 16:45:21 GMT

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;

Re: Searching and replacing characters

PaigeMiller — Sat, 30 Apr 2022 21:00:04 GMT

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.

Re: Searching and replacing characters

archita — Sun, 01 May 2022 07:43:23 GMT

Thanks , point noted.

Re: Searching and replacing characters

archita — Sun, 01 May 2022 07:44:45 GMT

Thank you, working now.