Dear Sir/Madam,
System information:
System information:
All previous steps and datasets are the same.
I'm interested in information about why in one situation code works and in another does not work.
Thanks!
The two systems have a different setting of the MERGENOBY system option.
The two systems have a different setting of the MERGENOBY system option.
thank you Kurt!
that is interesting that such small version difference has quite big default options difference, anyway "merge without by is not a really good idea", as we've found here: https://www.lexjansen.com/nesug/nesug09/ff/FF10.pdf
It seems that somebody has explicitly set the option on your Windows 10 / SAS 9.4M4 environment, as NOWARN is the shipped default.
PS post logs by doing a copy/paste into a window opened with the {i} button. It's quicker, and better to read.
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!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.