topic Re: how to merge two columns into single column in SAS Programming

how to merge two columns into single column

srav2 — Wed, 22 Nov 2017 09:52:06 GMT

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

Re: how to merge two columns into single column

PeterClemmensen — Wed, 22 Nov 2017 10:07:02 GMT

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;

Re: how to merge two columns into single column

srav2 — Wed, 22 Nov 2017 10:10:01 GMT

its a question asked in interview.

I tried different ways but couldnt get the result.

will try this.

Re: how to merge two columns into single column

srav2 — Wed, 22 Nov 2017 10:16:36 GMT

thanks a lot it worked..

Re: how to merge two columns into single column

srav2 — Wed, 22 Nov 2017 10:26:08 GMT

Could you please explain how this worked out.

Re: how to merge two columns into single column

Shmuel — Wed, 22 Nov 2017 11:17:30 GMT

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;