topic Re: Turn two columns into one in SAS Procedures

Turn two columns into one

TBanky — Tue, 09 Dec 2014 14:46:58 GMT

I want to do some sort of append - I have something like this:

var 1	var2	var3	1	2	3
vv	vv	vv	a	b	c
zz	zz	zz	e	f	g

And I want:

var1	var2	var3	l
vv	vv	vv	a
vv	vv	vv	b
vv	vv	vv	c
zz	zz	zz	d
zz	zz	zz	e
zz	zz	zz	f

How can I do this?

Thank you in advance!

LinusH — Tue, 09 Dec 2014 16:00:40 GMT

proc transpose or a data step using explicit output statment.

user24feb — Tue, 09 Dec 2014 17:17:46 GMT

An array could work as well (there is no "d" in your original data):

Data Have;
Input Var1 $ Var2 $ Var3 $ x_1 $ x_2 $ x_3 $;
Datalines;
zz zz zz e f g
vv vv vv a b c
;
Run;

Data Want (Drop=x_:);
Set Have;
Array A $ x_:;
Do over A;
L=A;
Output;
End;
Run;

Proc Print Data=Want Noobs; Run;