SAS mm/dd/yyyy hh:mm:ss AM/PM

[Kurt_Bremser]

So each data item has its own line, and there are empty lines interspersed?

What does "BA" signify? Is it a kind of group value, or does it need to be discarded like the "contact_date" line?

[Kurt_Bremser]

Your datetime string looks different in every one of your posts.

Here, it has leading blanks and two blanks between date and time:

          6/30/2010  12:00:00 AM
          6/25/2010  12:00:00 AM
          5/6/2010  12:00:00 AM

But here, there are no leading blanks, and there's only one blank separating date and time:

BA

contact_date

1/1/2012 12:00:00 AM

12/23/2004 12:00:00 AM



contact_date 

03/04/2005 12:00:00 AM 



contact_date 

12/13/2004 12:00:00 AM

 So, what is it?

As has been requested repeatedly, open the text file with a TEXT EDITOR, and COPY/PASTE the contents into a code window. Only then will we be able to provide help with code that works with your data.

Norte that Excel files are useless for describing text files. Excel does all kinds of things when opening such files.