Date:         Mon, 7 Jul 2008 16:17:40 -0400
Reply-To:     "Howard Schreier <hs AT dc-sug DOT org>"
              <schreier.junk.mail@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Howard Schreier <hs AT dc-sug DOT org>"
              <schreier.junk.mail@GMAIL.COM>
Subject:      Re: PROC FREQ AND TRANSPOSE

On Mon, 7 Jul 2008 13:06:21 -0700, Jerry <lihais@GMAIL.COM> wrote:

>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!

See Generating Zeroes in PROC TRANSPOSE Output in the wiki

http://www.sascommunity.org/wiki/Generating_Zeroes_in_PROC_TRANSPOSE_Output