topic Re: How to change BEST12 to MMDDYY10. in SAS Procedures

How to change BEST12 to MMDDYY10.

AMFR — Tue, 05 Jun 2018 13:34:10 GMT

I have a numeric date variable with the format BEST12 and informat BEST32 assigned to it. I want to change it to MMDDYY10. How can I do this?

Thanks in advance

RW9 — Tue, 05 Jun 2018 13:45:39 GMT

Post example test data in the form of a datastep. Otherwise I am just guessing what you have! Is it looking like this?

data want;
  num_var=20180212;
  date_var=input(put(num_date,8.),yymmdd8.);
  format date_var date9.;
run;

AMFR — Tue, 05 Jun 2018 13:48:33 GMT

Yes, you are right.

I just figured this out. This is what I am doing and it works. Thank you very much.

data temp;

set flowsheet;

service_day2= input(put(service_day, z8.),yymmdd8.);

format service_day2 mmddyy10.;

drop service_day;

rename service_day2= service_day;

run;