Concatenation

[Nasya]

Hi,

I need help in concatenation.

I have two variables : ID Agent and Agentoth (all CHAR)

Sample data:              01 Steriods     ABC

                                   02 Other          XYZ

                                   03 ATG

Expected out put is : Agent,agentoth

data med;
     by ID;
     attrib AGENT_ length=$100;

if index(lowcase(AGENT),"other")>0 then do;
		AGENT_= "Other, "|| AGENTOTH; 
 	end;
 	if AGENT_ =" " then AGENT_ = AGENT;

	output step_01_dat_final;
run;

This code above concatenates only if the agent name is 'Other'. I need to concatenate if there is anything in the Agenoth, else leave.

Any suggestions?

Thank you,

Regards,

Nasya

[Reeza]

I believe the CAT_ family of functions do that automatically, so you don't need to account for that.

data have;
infile cards truncover;
input id $ agent $ agentoth $;
cards;
1 Fred Flinstone
2 Angela
3 Barney Rubble
;;
run;

data want;
set have;

var = catx(', ', agent, agentoth);
run;

---

@Nasya wrote:

Hi,

I need help in concatenation.

I have two variables : ID Agent and Agentoth (all CHAR)

Sample data:              01 Steriods     ABC

                                   02 Other          XYZ

                                   03 ATG

Expected out put is : Agent,agentoth

data med;
     by ID;
     attrib AGENT_ length=$100;

if index(lowcase(AGENT),"other")>0 then do;
		AGENT_= "Other, "|| AGENTOTH; 
 	end;
 	if AGENT_ =" " then AGENT_ = AGENT;

	output step_01_dat_final;
run;

This code above concatenates only if the agent name is 'Other'. I need to concatenate if there is anything in the Agenoth, else leave.

Any suggestions?

Thank you,

Regards,

Nasya

---