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: 
piPy
‎04-03-2019
  • 2 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Product Combinations and Permutations By ID

by Calcite | Level 5 in SAS Programming
‎04-01-2019 06:50 PM
‎04-01-2019 06:50 PM
Hi @ballardw,   68 is the all the products, if this is a problem then I just limit to the top 30 products. By the way having a large output data set is not a problem for me.   I have looked at examples of using array and ALLCOMB function but none fit my problem, I'm also examining the ALLPERM as per your suggestion.   Thank you, ... View more

Product Combinations and Permutations By ID

by Calcite | Level 5 in SAS Programming
‎04-01-2019 08:30 AM
‎04-01-2019 08:30 AM
Hi,   I have an over simplified data set that looks like    ID Prod_Cat Prod 1111 PN1 1 1111 PN2 2 1111 PN3 3 1111 QC1 4 1111 QC2 5 2222 PN1 2 2222 PN2 3 2222 PN3 4 2222 QC1 5 2222 QC2 6   And I would like to have an output data set (already sorted) that looks like the attached csv file. The actual number of products are 68 and products categories is 10. I have consulted the similar topics on sas community forum but none does what I'm after. Much appreciated for any assistance or pointers how I can get to this final result.   Thank you ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎04-03-2019 09:26 PM
Quick links