| Date: | Thu, 13 Jan 2000 09:57:42 -0500 |
|---|
| Reply-To: | Y.Huang@ORGANONINC.COM |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Ya Huang <Y.Huang@ORGANONINC.COM> |
|---|
| Subject: | Re: Tabulate question |
|---|
|
| Content-type: | text/plain; charset="iso-8859-1" |
|---|
Sorry, there is a "cut and past" error,
the sql part should be:
proc sql;
create table yy as
select 'Var1' as var_name,
sum(var1=1) as n1,
sum(var1=2) as n2,
sum(var1=3) as n3,
sum(var1=4) as n4,
sum(var1=5) as n5
from xx
union
select 'Var2' as var_name,
sum(var2=1) as n1,
sum(var2=2) as n2,
sum(var2=3) as n3,
sum(var2=4) as n4,
sum(var2=5) as n5
from xx
union
select 'Var3' as var_name,
sum(var3=1) as n1,
sum(var3=2) as n2,
sum(var3=3) as n3,
sum(var3=4) as n4,
sum(var3=5) as n5
from xx;
|
