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
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.
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.