@titus Idea of custom function isn't bad, but I would 0 and the alignment parameter as in the documentation example.
proc fcmp outlib = dmudfs.UDF.UDF;
function FirstOfMonth(dt);
/* Purpose: Return the first day of month from either a Date or DateTime argument*/
if dt/86400 > 1 then FOM = intnx('day', datepart(dt), 0, 'b');
else FOM = intnx('day', dt, 0, 'b');
return(FOM);
endsub;
function LastOfMonth(dt);
/* Purpose: Return the last day of month from either a Date or DateTime argument*/
if dt/86400 > 1 then LOM = intnx('day', datepart(dt), 0, 'e');
else LOM = intnx('day', dt, 0, 'e');
return(LOM);
endsub;
quit;
... View more