Guesses based on on code or data:
The input data is not exactly the same and there is a duplicate in one of the data sets that is not accounted for in the code somewhere, given the error, likely a PROC TRANSPOSE.
If the input data is the same, and you've used PROC IMPORT, it's possible the import truncated some data to create duplicate keys which may not have existed in the other version. PROC IMPORT guesses at types and lengths and not always correctly.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.