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?
You will find your answer in this thread:
https://communities.sas.com/t5/SAS-Programming/proc-transpose/td-p/611842
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.
You will find your answer in this thread:
https://communities.sas.com/t5/SAS-Programming/proc-transpose/td-p/611842
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! 🙂
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: