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!
proc sql;
create table want as
select
t1.*
from
crspcommon_list t1
left outer join present_io_list t2
on
t1.dateval = intnx('month',t2.dateval,0,'end')
/*and any other match keys*/
where
t2.dateval is null;
quit;
Pls take a look at the INTNX function.
proc sql;
create table want as
select
t1.*
from
crspcommon_list t1
left outer join present_io_list t2
on
t1.dateval = intnx('month',t2.dateval,0,'end')
/*and any other match keys*/
where
t2.dateval is null;
quit;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.