How to verify correct format for Date of Birth?

vaidas — Wed, 26 Feb 2020 09:46:22 GMT

The data already exist on the table. It is required to verify of Date of Birth is in correct format. Currently Date of Birth field is in $CHAR10. format. It is not required to fix wrong format cases just identify them. The required format is dd/mm/yyyy. How to retrieve output were below mentioned cases doesn't meet format = dd/mm/yyyy. Thanks in advance.

Sample of data:

1963/12/31

31/12/2007
31/12/2008
31/12/2009
31/12/2010
31/12/2011
31/12/2012
31/12/2013
31/12/2014
31/12/2015
31/12/2016
31/12/2018
?

Re: How to verify correct format for Date of Birth?

ed_sas_member — Wed, 26 Feb 2020 10:01:07 GMT

Hi @vaidas

I suggest that you use the input function, so that SAS try to convert the character value to SAS date value:

data want;
	set have;
	if input(date, ddmmyy10.) ne . then valid_date = 'Y';
	else valid_date = 'N';
run;

topic How to verify correct format for Date of Birth? in SAS Programming

How to verify correct format for Date of Birth?

Re: How to verify correct format for Date of Birth?