A lot of people won't download files for security reasons. You will make it much easier for people to help you if you post example data you HAVE as a DATA step with the CARDS statement (with 10-20 records, showing the different scenarios). And also include the data you WANT to generate. Also suggest including the code you have tried, and any problems with your code (wrong result, error message, etc.) .
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.