Linked Questions

Popular Questions

Convert character date into numeric in SAS

Asked by At

I have a character variable which contains dates like (string length is 30):

Mon Jul 24 02:48:17 -0700 2017
------------------------------ ruler
123456789012345678901234567890
         1         2         3

How can I extract the usable(date,month,year) date and save it as numeric date. I know how to do it by using SUBSTR function and then concatenating everything together. But I want to know a easier and quick way. I tried using ANYDTDTE informat to read it, but got blank values. Let me know if there is any simpler way to read this date.

Related Questions