I want to convert a sas date to Teradata date in the where clause below:
create table temp_4 as
select a.counter, max(c.ID) as CI_ID
from temp_3 a
left join table.abc b ON a.H_ID = b.X_ID
inner join table.def c ON b.CI_ID = c.CI_ID
left join table.ghi d ON c.CI_ID = d.CI_ID
where b.type ='HI' and substr(c.CI_LAST_NM,1,12) = a.Surname and substr(c.CI_FRST_NM,1,7) = a.First_Name
and c.CI_BIR_DT = a.DOB and c.CI_SEX_C = a.gen
group by a.counter
c.CI_BIR_DT = a.DOB CI_BIR_DT is a Teradata date and a.DOB is the sas date.
I tried a few options but failed to get the correct result. Please advise.
Try formatting temp_3.DOB as format yymmdd10. before joining. That's worked before.
Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.
Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for:
View all other training opportunities.