Many users here don't want to download Office files because of virus potential, others have such things blocked by security software. Best to post directly into the message windows or a link. If that isn't possible then a somewhat less problematic file format like PDF.
You should also describe, or better yet, provide an example of the input data using DATA step code pasted into a text box opened on the forum with the </> icon that appears above the message windows. A working data step means we don't have to make any guesses about variable type, names or properties.
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.