how to merge two columns into single column

[srav2]

Hi,

I'm having a dataset shown as below and all the variables are characters. I need a output in which TERM variable is having the values of both TERM and WORD. PLease help

Thanks in advance.

INPUT:

TERM             WORD                   

Cold                chills                       

Fever              HIgh temperature     

Headache       dizziness                   

OUTPUT:

TERM

 Cold

 chills

  fever

  high temperature

  Headache

 dizziness

[PeterClemmensen]

There are numerous ways to do this and it is fairly easily done, but I have to ask why? This does not make sense to me? 🙂

data have;
length TERM $50 WORD $50;
input TERM$ WORD$;
infile datalines dlm=',';
datalines; 
Cold,chills                       
Fever,HIgh temperature     
Headache,dizziness
run; 

data want(keep=TERM);
	set have;
	array vars{*} TERM WORD;
	do i=1 to dim(vars);
		TERM=vars[i];
		output;
	end;
run;

[srav2]

its a question asked in interview.

I tried different ways but couldnt get the result.

will try this.

[srav2]

thanks a lot it worked..

[srav2]

Could you please explain how this worked out.

[Shmuel]

If you are not familiar with arrays, next code is same as @PeterClemmensen's code (but his code is flexible to deal with more than 2 variables):

data want(keep=TERM);
	set have;
	output;   /* original TERM only */
        term = word;
       output;   /* = WORD value */ 
run;