topic Re: transpose in SAS Programming

transpose

radhikaa4 — Tue, 17 Dec 2019 15:15:25 GMT

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?

Re: transpose

PaigeMiller — Tue, 17 Dec 2019 15:25:00 GMT

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-data-AKA-generate/ta-p/258712

We would be much happier when you do this.

Re: transpose

ghosh — Tue, 17 Dec 2019 16:29:52 GMT

You will find your answer in this thread:

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

Re: transpose

novinosrin — Tue, 17 Dec 2019 17:07:56 GMT

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! 🙂