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 ? ... View more

Input function is failing to convert in to numeric: Field :Len=3, $CHAR3.  Using input function I am getting '.' for characters 1 to 99 and conversion works only for characters 100 to 999. What could be done  for this large data set analysis?    Proc SQL ; Create Table Test As Select distinct input(A.Field,8.) as Field1, count(A.ID) as Field2 From &Source_Curr as A group by A.ID HAVING Field1 <> Field2   Field values: 1 10 11 12 13 14 15 159 16 17 18 19 2 20 228 24 243 25 26 27 29 3 33 37 4 46 5 55 59 6 7 78 8 82 9 ? Above mentioned values are part of the large existing data set that is part of SAS library.  ... View more