topic how to tranpose dataset with variable having duplicate value? in New SAS User

how to tranpose dataset with variable having duplicate value?

yogita_patel — Thu, 21 Apr 2022 18:34:56 GMT

I would like to transpose dataset below

to this

for each treatment ;

Re: how to tranpose dataset with variable having duplicate value?

PaigeMiller — Thu, 21 Apr 2022 18:48:52 GMT

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

Re: how to tranpose dataset with variable having duplicate value?

Reeza — Thu, 21 Apr 2022 23:09:10 GMT

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;

Re: how to tranpose dataset with variable having duplicate value?

Kurt_Bremser — Fri, 22 Apr 2022 05:59:19 GMT

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.