SAS proc sql 将2列变成1列

Question

假设我有一张 table

 A     |  B
===============
Dan    | Jack
April  | Lois
Matt   | Davie
Andrew | Sally

我想做一张 table

 C     
======
Dan  
April 
Matt   
Andrew 
Jack
Lois
Davie
Sally

使用 SAS proc sql。我怎样才能做到这一点？

Answer 1

data have;
input A $ B $;
datalines;
Dan Jack
April Lois
Matt Davie
Andrew Sally
;
run;

proc sql;
create table want as 
select A as name from have
union all
select B as name from have;
quit;