topic Re: End of Month Dates in SAS Procedures

End of Month Dates

Benn — Wed, 13 Feb 2013 14:31:32 GMT

Hi Guys,

I have currently have 2 sets of data:

SET A has dates that are at the end of every month

SET B has dates that MAY NOT be at the end of every month

I am trying to use this code to isolate a new set of data:

PROC SQL NOPRINT;

CREATE TABLE ABSENT_IO_LIST

AS SELECT * FROM CRSPCOMMON_LIST

EXCEPT

SELECT * FROM PRESENT_IO_LIST;

However the differential dates are forbidding me to do so. It is crucial that I retain the dates in SET A for later purposes. So I was hoping that there is a code that automatically moves the dates in SET B to the end of the month, thereby allowing me to use my code above as well as to retain the dates in SET A. (Any other solutions would be greatly appreciated too!)

Thanks a lot guys! It is much appreciated!

Re: End of Month Dates

LinusH — Wed, 13 Feb 2013 14:41:30 GMT

Pls take a look at the INTNX function.

Re: End of Month Dates

DBailey — Wed, 13 Feb 2013 14:54:51 GMT

proc sql;

create table want as

select

t1.*

from

crspcommon_list t1

left outer join present_io_list t2

t1.dateval = intnx('month',t2.dateval,0,'end')

/*and any other match keys*/

where

t2.dateval is null;

quit;