How to stack columns within the same table?

ismahero — Wed, 20 Feb 2013 23:50:23 GMT

HI...

I have a tale with 4 columns, and I want to stack them and have an output table of just 2 columns.

Example:

Original Table:

SSN Code Spouse SSN S Code

111-11-1111 5 222-22-2222 6

333-33-3333 5 444-44-4444 1

Desired Table:

SSNs Codes

111-11-1111 5

333-33-3333 5

222-22-2222 6

444-44-4444 1

Is there any way of doing this...? Thanks for your help, I am kind of new with SAS EG...

Re: How to stack columns within the same table?

Linlin — Thu, 21 Feb 2013 01:15:23 GMT

try:

data temp1(keep=ssn code) temp2(keep=s_ssn s_code rename=(s_ssn=ssn s_code=code));

set have;

data want;

set temp1 temp2;

run;