topic Re: Date stored as number format shows as dmmyyyy in SAS Programming

Date stored as number format shows as dmmyyyy

cxkev — Thu, 06 Mar 2014 14:42:56 GMT

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

Re: Date stored as number format shows as dmmyyyy

BrunoMueller — Thu, 06 Mar 2014 15:11:13 GMT

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
;

Re: Date stored as number format shows as dmmyyyy

cxkev — Thu, 06 Mar 2014 15:58:22 GMT

Excellent. Thank you Bruno.