Date stored as number format shows as dmmyyyy

[cxkev]

Good Afternoon,

I am querying a dataset where the date field is stored as a number format, however, the number is dmmyyy, so for example, 1st Apr 2013 shows as as 10413, 31st Dec 2013 shows as 31122013.

Is there any code that would convert this to a recognisable date format so SAS would recognise it was a date and if date9. format was applied would show 01APR2013 and 31DEC2013?

Kind Regards,

cxkev

[BrunoMueller · Accepted solution]

Have a look at the code below, you need to first convert from numeric to char and then use appropriate informat to make a SAS date from the char variable

data want;
  infile cards dlm=",";
  input
    @1 date_n  8.
  ;
  * convert numeric to char left aligned ;
  date_c = put(date_n, 8. -L);
  * convert from char to SAS date ;
  date_s = input( date_c, ddmmyy8.);
  format date_s date9.;
cards;
10413
31122013
;

[cxkev]

Excellent. Thank you Bruno.