Concatenation

Nasya — Thu, 26 Jul 2018 15:13:54 GMT

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

Re: Concatenation

Reeza — Thu, 26 Jul 2018 15:31:18 GMT

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

topic Concatenation in SAS Programming

Concatenation

Re: Concatenation