transpose

[radhikaa4]

I currently have this table below

reasons_list	answer	frequency	percent
reason #1	no
reason #1	yes
reason #2	no
reason #2	yes

I would like the table below

reasons_list	no_frequency	no_percent	yes_frequency	yes_percent
reason #1
reason #2

I tried with proc transpose and it works but i have to do multiple transposes. Is there any way to fix with just 1-2 two steps?

[PaigeMiller]

At this point @radhikaa4, you have asked enough questions and we have helped you enough so that I think you need to help us now.

Post data according to the following instructions: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

We would be much happier when you do this.

[ghosh · Accepted solution]

You will find your answer in this thread:

https://communities.sas.com/t5/SAS-Programming/proc-transpose/td-p/611842

[novinosrin]

In addition to @PaigeMiller, It is my humble request you could mark the solutions as answered and close the threads. This helps new folks who contribute feel more encouraged and at the same-time makes the discussion interactive from start to finish. 

Of course not really a bother for somebody like Paige at this point having been here for long, and  even I could care less these days for the feeling that it's already been a journey with the community, nonetheless it can only help. We're all human with responsiveness after all! 🙂