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
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
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
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:
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.