how to tranpose dataset with variable having duplicate value?

[yogita_patel]

I would like to transpose dataset below

to this

for each treatment ;

[PaigeMiller]

This isn't a transpose. Please take a look at the %TABLEN macro.

[Reeza]

Your displayed data set doesn't have duplicates that I can see. This won't give you the formatting youw ant but it's close. The label of 'without adverse event likely belongs to the TRTAN column.

proc transpose data=have out=want;
by trtan;
id aesevn;
idlabel aesev;
var count;
run;

[Kurt_Bremser]

That's not a transpose, it's a report.

Please supply data in usable form (data step with datalines), including the formats used to translate to the displayed texts.