Thanks Anurag12 for your reply. But the source data (in csv file) is in sas format and numeric that is why I did not provide any format. Looks like dates are correct. Also the informat propcase for state did not work, while upcase for state worked. Where can I find the answers to verify my work. TsaRaw: 220,855 rows TsaUnique claim#: 220,828 rows TsaClean after putting all requirements: 219441 rows I got 4007 date issues.
... View more