Proc Transpose

[unnati]

Hello,

Can anyone help me with proc transpose . I would like to use PROC Transpose procedure for following output.

My desire output is as follow. Can someone explain me with PROC transpose code. how do i get my desire output.

proc transpose data=lll;
		by trt;
		id order;
		var count;
		run;

I use this code but not able to get desire output

[Reeza · Accepted solution]

Think of ID as the column identifiers and BY as the row identifiers. You have yours backwards.

---

@unnati wrote:

Hello,

Can anyone help me with proc transpose . I would like to use PROC Transpose procedure for following output.

My desire output is as follow. Can someone explain me with PROC transpose code. how do i get my desire output.

proc transpose data=lll;
		by trt;
		id order;
		var count;
		run;

I use this code but not able to get desire output

---

[ballardw]

We can't write code from pictures.

Provide you example input data in the form of a data step.

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat... will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

Do you want a report, read by people, or a data set to send to another procedure?

The output below looks suspiciously like the output of a SAS report procedure. Such as

proc tabulate data=lll;

   class trt order;

   freq count;

   tables order, trt

   ;

run;

---

@unnati wrote:

---