Pleas when discussing a proposed solution show from the log the code and any notes from SAS.
Sometimes we use generic bits, such as data set names, because you haven't provided yours completely. Then your code that you execute may include some of these bits. Which may result in an error and not replace a previously created data set from when you were attempting your solutions. So we need to know what happens when your code gets different results.
You might be surprised how many people will type code from a proposed solution and completely rewrite it missing key syntax elements.
... View more