topic How to convert date format with multiple date format in one column in SAS Programming

How to convert date format with multiple date format in one column

raja777pharma — Mon, 15 Jul 2024 04:55:09 GMT

Hi Team,

I am trying to convert the dates below to IS8601DA , but one date was not considering that one is in date9. format.

Thank you,

Raja.

Re: How to convert date format with multiple date format in one column

ChrisNZ — Mon, 15 Jul 2024 05:48:09 GMT

I am trying to convert the dates below to IS8601DA

Are you trying to convert strings to SAS dates with a IS8601DA format?

If so:

data HAVE; 
  A='2014-05-01T05:01'; output;
  A='2014-05-01      '; output;
  A='12oct2014       '; output;
run;
  
data WANT;
  set HAVE;
  DATE=input(A,anydtdte10.);
  format DATE date9.;
  put DATE=;
run;

DATE=01MAY2014

DATE=12OCT2014

Re: How to convert date format with multiple date format in one column

Kurt_Bremser — Mon, 15 Jul 2024 08:32:22 GMT

What is your original data source?

Should the values be stored as dates only, as datetimes, or as separate date and time?