how to convert a date ddmmyyn8 to ddmmyy10.

[alepage]

hello,

I would like to know if there is a way to convert a date (ddmmyyn8) to another date format (ddmmyy10) using proc sql alter table modify?

Regards,

[Kurt_Bremser]

For "attribute surgery" like that, proc datasets is the method of choice.

[alepage]

Hello,

I am not familiar with proc dataset.

However, I have tried this peace of code and it seems to work.

Is It correct?

proc datasets lib=work;
modify BaseAV2017;
format EffDate yymmdd10.;
quit;

[Kurt_Bremser · Accepted solution]

---

@alepage wrote:

Hello,

I am not familiar with proc dataset.

However, I have tried this peace of code and it seems to work.

Is It correct?

proc datasets lib=work;
modify BaseAV2017;
format EffDate yymmdd10.;
quit;

---

This is correct. It only changes the header information of the dataset and is therefore very efficient.

[alepage]

Thanks a lot for your Help Kurt

Best Regards