topic Re: "Merge" statement with and without error dependence from system: "No BY statement in New SAS User

"Merge" statement with and without error dependence from system: "No BY statement was specified for"

AndreyMyslivets — Tue, 30 Jul 2019 05:07:12 GMT

Dear Sir/Madam,

Could you please provide me with the information where I can find the reason why the same code on different systems gives different results (with error and without error):

1. Result 1 (without error).

System information:

2. Result 2 (with error).

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!

Re: "Merge" statement with and without error dependence from system: "No BY statement

Kurt_Bremser — Tue, 30 Jul 2019 05:27:37 GMT

The two systems have a different setting of the MERGENOBY system option.

Re: "Merge" statement with and without error dependence from system: "No BY statement

Kurt_Bremser — Tue, 30 Jul 2019 05:28:43 GMT

PS post logs by doing a copy/paste into a window opened with the {i} button. It's quicker, and better to read.

Re: "Merge" statement with and without error dependence from system: "No BY statement

AndreyMyslivets — Tue, 30 Jul 2019 06:50:10 GMT

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

Re: "Merge" statement with and without error dependence from system: "No BY statement

Kurt_Bremser — Tue, 30 Jul 2019 07:49:49 GMT

It seems that somebody has explicitly set the option on your Windows 10 / SAS 9.4M4 environment, as NOWARN is the shipped default.