Re: Rename the values in String variable

anilgvdbm — Sun, 13 Jan 2019 05:47:27 GMT

Dear All,

I have some product names in the product variable i want to rename some of the strings in that variable let's say Anil, Anilkumar, Ani - rename to Anilkumar and create new product variable.

Here i have product names dictionary in another file. now i want to map the product names from raw data with product name dictionary.

I want to use Loops for this because i want to generate weekly and monthly reports.

Can we automate this?

Regards.

Kumar

Re: Rename the values in String variable

LinusH — Sun, 13 Jan 2019 08:43:44 GMT

For mappings, yo usually don't do loops (at least not in SAS).

You can do table look-ups in several ways, including SQL join, and put function using a user defined format (created from your mappng table).

topic Re: Rename the values in String variable in New SAS User

Re: Rename the values in String variable

Re: Rename the values in String variable