topic Re: mergenoby in SAS Programming

mergenoby

ieva — Tue, 31 Aug 2010 07:16:17 GMT

Hi,

I know that there is such a MERGENOBY option. Is there also something similar that would work something like SET NO BY but, for example, just in cases if you use FIRST.variable or LAST.variable? (Option that would not let you use first.variable if you don't use BY statement?)

Seems too complicated to really have such, but maybe you know some trick how not to forget BY statement in such cases 🙂

Thanks,
Ieva

Re: mergenoby

Peter_C — Tue, 31 Aug 2010 10:36:59 GMT

no options seem to support this (although I think there is a SAS92 feature which would convert a lot of NOTE messages into ERROR or WARNING).
If you want a quick check, search for strings
"NOTE: Variable first." and "NOTE: Variable last."
could be worth a ballot item http://support.sas.com/community/ballot/ or "Suggestion" at http://support.sas.com/contact/software_comments.html

peterC

Re: mergenoby

data_null__ — Tue, 31 Aug 2010 11:59:26 GMT

The undocumented DSOPTIONS may be useful.

[pre]
120 options dsoptions=note2err;
121 data test;
122 set sashelp.class;
123 if first.name then;
124 run;

ERROR: Variable first.name is uninitialized.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.TEST may be incomplete. When this step was stopped there were 0
observations and 5 variables.
WARNING: Data set WORK.TEST was not replaced because this step was stopped
[/pre]

Re: mergenoby

ieva — Tue, 31 Aug 2010 12:10:40 GMT

Great thanks Peter and data _null_! That is the option I was searching for.