Date:         Mon, 7 Jul 2008 16:14:09 -0400
Reply-To:     msz03@albany.edu
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mike Zdeb <msz03@ALBANY.EDU>
Subject:      Re: PROC FREQ AND TRANSPOSE
Content-Type: text/plain;charset=iso-8859-1

hi ... have you tried ...

table ... / sparse out=.. ;

for example ...

proc freq data=sashelp.class;
table sex*age / sparse out=t;
run;

proc transpose data=t out=tt (drop=_:) prefix=age;
var count;
by sex;
id age;
run;

proc print data=tt;
run;

will have a zero count for 16 year old females (none in the data set)

--
Mike Zdeb
U@Albany School of Public Health
One University Place
Rensselaer, New York 12144-3456
P/518-402-6479 F/630-604-1475

> Hello all,
>
> Sorr for the part of question!
>
> I got the result from the proc freq.
>
> Preferred Term   severity  count
>
> Dizziness         mild           1
> Dizziness         severe        2
> Headache          moderate   2
> Headache          severe       3
> Sensory loss      mild          5
> Lethargy          mild            4
> Lethargy          moderate     7
> Lethargy          Severe        6
>
> I want to transpose to get the result like:
>
> Preferred term  mild  modereate  severe
> Dizziness         1          0             2
> headache         0          2             3
> sensory loss    0          0             3
> leahargy          4          7             6
>
> How can I do the transpose and get the result for missing level of
> severity?
>
> Thanks in advance!
>
>