DATA Step, Macro, Functions and more

date time to date format

Accepted Solution Solved
Reply
Contributor
Posts: 41
Accepted Solution

date time to date format

i have a datetime format variable "2016-09-20T08:29" which is character format and another date "2016-05-04" character.

I need to check if both the dates are same for each record and using the code below.

proc sql;
create table rand_date as
select a.usubjid,a.RFSTDTC,b.SCDTC
from sdtm.dm a left join sdtm.sc b
on a.usubjid=b.usubjid
where (a.ARMCD ne "SCRNFAIL") and a.RFSTDTC ne b.SCDTC;
quit;

 

But due to different date formats it is not working.

can any one suggest how to proceed.

 

 


Accepted Solutions
Solution
‎04-04-2017 05:07 AM
Super User
Super User
Posts: 7,942

Re: date time to date format

Posted in reply to alexdsa310

If they are both strings then this is simple string manipulation:

where (a.ARMCD ne "SCRNFAIL") and substr(a.RFSTDTC,1,10) ne b.SCDTC;

If they are a numeric date-time and a date then simply:

where (a.ARMCD ne "SCRNFAIL") and datepart(a.RFSTDTC) ne b.SCDTC;

View solution in original post


All Replies
Solution
‎04-04-2017 05:07 AM
Super User
Super User
Posts: 7,942

Re: date time to date format

Posted in reply to alexdsa310

If they are both strings then this is simple string manipulation:

where (a.ARMCD ne "SCRNFAIL") and substr(a.RFSTDTC,1,10) ne b.SCDTC;

If they are a numeric date-time and a date then simply:

where (a.ARMCD ne "SCRNFAIL") and datepart(a.RFSTDTC) ne b.SCDTC;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 124 views
  • 0 likes
  • 2 in conversation