BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
radhikaa4
Calcite | Level 5

I currently have this table below

 

reasons_listanswerfrequencypercent
reason #1no  
reason #1yes  
reason #2no  
reason #2yes  

 

I would like the table below

reasons_listno_frequencyno_percentyes_frequencyyes_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?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
3 REPLIES 3
PaigeMiller
Diamond | Level 26

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.

--
Paige Miller
ghosh
Barite | Level 11
novinosrin
Tourmaline | Level 20

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

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 525 views
  • 3 likes
  • 4 in conversation