Hi,
I am new to SAS and I want to compare the below fields in the same table
Please let me know how to compare the two different datatype ?
Sr_date mentioned as varchar_type
dt_date mentioned as date_type
Example
sr_date dt_date
10/05/2014 14:01:18 2014-10-05
Date values should be same in both fields .if anyting mismatched, query should pick the unmatched record
Please let me know how to write a query for the above scenario?
if dt_date = input(substr(sr_date,1,10),ddmmyy10.) then do .....
BTW, SAS only knows two data types, character and numeric.
'SAS dates' are numeric values containing the number of days since 01/01/1960 and having one of the date formats assigned.
There are no varchar variables in SAS, only fixed length character.
Are you working with a SAS dataset or an external database? If the later you may have to specify which as there are some gotcha's depending.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.
Ready to level-up your skills? Choose your own adventure.