cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Mentu
‎04-04-2019
  • 1 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Combining multiple columns into 1

by Calcite | Level 5 in SAS Programming
‎04-04-2019 09:22 AM
‎04-04-2019 09:22 AM
I have this data                     Country  Month year  Apples  Oranges  Mango  USA Jan 2018 0 3 0 USA Jan 2018 1 1 0 USA Feb 2018 1 0 1 USA Feb 2018 0 2 2 USA Feb 2018 0 0 1   I want to to combine the fruit columns into 1 separate 'Fruit' column and their corresponding  frequency. How do i do this with SAS base? Country  Month year  Fruit type Number               USA Jan 2018 Apples 0               USA Jan 2018 Apples 1               USA Feb 2018 Apples 1               USA Feb 2018 Apples 0               USA Feb 2018 Apples 0               USA Jan 2018 Oranges 3               USA Jan 2018 Oranges 1               USA Feb 2018 Oranges 0               USA Feb 2018 Oranges 2               USA Feb 2018 Oranges 0               USA Jan 2018 Mangos 0               USA Jan 2018 Mangos 0               USA Feb 2018 Mangos 1               USA Feb 2018 Mangos 2               USA Feb 2018 Mangos 1               ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-04-2019 12:42 PM
Quick links