SAS Procedures

Help using Base SAS procedures
BookmarkSubscribeRSS Feed
pp2014
Fluorite | Level 6

I have the product field with following info:

 

Product

 

Atrilin  Amox HC  Retin-A Micro

Tobi Cream Luzu Cream

 

 

I want the output as follows:

 

Product

 

Atrilin  AmoxHC  Retin-AMicro

TobiCream LuzuCream

 

I tried compbl function but it does not work.

 

I would appreciate any help with this.

1 REPLY 1
Reeza
Super User
y = tranwrd(x, " Cream", "Cream");

@pp2014 wrote:

I have the product field with following info:

 

Product

 

Atrilin  Amox HC  Retin-A Micro

Tobi Cream Luzu Cream

 

 

I want the output as follows:

 

Product

 

Atrilin  AmoxHC  Retin-AMicro

TobiCream LuzuCream

 

I tried compbl function but it does not work.

 

I would appreciate any help with this.


 

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 783 views
  • 0 likes
  • 2 in conversation