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: 
pfdjadsfdsafas
‎06-20-2019
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

How to transpose & combine a text field with multiple values for each ...

by Calcite | Level 5 in SAS Programming
‎06-06-2019 04:50 PM
‎06-06-2019 04:50 PM
Here is what I have: ID Category 1 Dog 1 Cat 2 Horse 3 Dog 3 Horse 3 Cat And what I need is something along the lines of this: ID Category 1 Dog + Cat 2 Horse 3 Dog + Cat + Horse I can think of some very roundabout ways to do this but there has to be a simple quick way. Thanks! ... View more

Create a variable number of new lines by and ID dependent on months to...

by Calcite | Level 5 in SAS Programming
‎03-06-2019 02:31 PM
‎03-06-2019 02:31 PM
First post here, so sorry about formatting/missing details.   I have a data set that is just a numeric ID and a month value that is a string in format YYYY-M (e.g. September 2017 would be 2017-9). All of the values are in 2017 or 2018. I need to create a row for each ID for each month from the value provided up to December 2018. I also have these dates in a raw date format as well if that would make this easier.   So for example, the input 5134223 2018-10  Would need to output   5134223 2018-10 5134223 2018-11 5134223 2018-12 ^having trouble with the formatting here but these should be on 3 separate lines.   If anyone can provide any help that would be amazing. Again, I can get these dates in a normal date format but the way I have been approaching it was going to use it as a string until I got stuck.  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎06-20-2019 02:07 PM
Quick links