Date:         Wed, 6 May 2009 03:24:16 -0700
Reply-To:     RAMS <ramsathish@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         RAMS <ramsathish@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Question in Proc Transpose
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Dear All,

        I have a dataset like the following

data c;
input age_cat id severity $ sbp;
cards;
1   101   sev     169
1   102   sev     170
2   201   mild    155
2   212   mod    156
2   215   mild     163
;
run;

after i transpose this i got,

id age_cat sev mild mod
101   1   169    .    .
102   1   170    .    .
201   2      .    155

since the agegroup 1 does not have any  mild or moderate, it is not
creating the columns, it creates sev first.  How can i control this.

Please help me out.

Thanks in advance.

Regards,

Ramsathish S