BookmarkSubscribeRSS Feed
rashmirao99
Fluorite | Level 6

Hi

      I need to concatenate two varaibles is dataset. two variables are dose and doseu.

for example:

 

      dose    doseu

       20        ml

I want to create one variable by combining these two. And expecting the result like below. I need to add parentheses to the second variable.

 

newvariable

20 (ml).

 

Thanks

Rashmi.

2 REPLIES 2
Reeza
Super User

Try the CATT() function. 

 


@rashmirao99 wrote:

Hi

      I need to concatenate two varaibles is dataset. two variables are dose and doseu.

for example:

 

      dose    doseu

       20        ml

I want to create one variable by combining these two. And expecting the result like below. I need to add parentheses to the second variable.

 

newvariable

20 (ml).

 

Thanks

Rashmi.


 

Astounding
PROC Star

One variation:

 

newvariable = catx( ' (', dose, doseu) || ')' ;

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 2 replies
  • 750 views
  • 0 likes
  • 3 in conversation