About Shara

PaigeMiller · ‎10-17-2013

I think you would want to use the INTNX function, with the alignment parameter set to E. You could also include this calculation in the %SYSFUNC macro function, and put it in a macro loop to increment to the last day of the next month each iteration of the macro.

Patrick · ‎10-10-2013

"The value of the minimum is stored for some row(s) of a group and thus the having statement will select the row(s) with value equal to minimum" That will work with SAS SQL but I'm pretty sure that with Oracle SQL it wouldn't and you have to use some function for all columns not being part of the group by clause. I'm not sure if this behaviour is Oracle specific or an "ANSI standard" but using a function will always work - and as I don't have experience with the Sybase SQL flavour that's what I proposed to be on the safe side. Else it's the sub-query as Reeza proposed.

Online Status	Offline
Date Last Visited	‎10-31-2020 12:36 PM

Macro to run the same code multiple times

Re: Self-Join Proc SQL

Re: Self-Join Proc SQL

Re: Self-Join Proc SQL

Self-Join Proc SQL

Re: Macro to run the same code multiple times

Re: Self-Join Proc SQL

SAS Analytics Explorers