topic Reformatting a date variable from YYYYMMDD to MM/DD/YYYY in SAS Programming

Reformatting a date variable from YYYYMMDD to MM/DD/YYYY

fordcr2 — Wed, 24 Jun 2020 19:05:16 GMT

Hello

I am trying to create a new variable from a date/time string of text that has the year, month day, hour, minutes, and seconds (yyyymmddhhmmss). I need to do two things:

1) truncate this variable so that it just has the month, day and year

2) reformat that to be mm/dd/yyyy

TIA!

Re: Reformatting a date variable from YYYYMMDD to MM/DD/YYYY

Kurt_Bremser — Wed, 24 Jun 2020 19:11:03 GMT

want = input(substr(have,1,8),yymmdd8.);
format want mmddyy10.;

Re: Reformatting a date variable from YYYYMMDD to MM/DD/YYYY

Tom — Wed, 24 Jun 2020 19:15:40 GMT

Do you want an actual DATE variable? Or another string variable?

data example;
  dtstring='20200624151423';
  date = input(dtstring,yymmdd8.);
  format date mmddyys10.;
  datestring=put(date,mmddyys10.);
run;