topic Re: how to convert a date ddmmyyn8 to ddmmyy10. in SAS Enterprise Guide

how to convert a date ddmmyyn8 to ddmmyy10.

alepage — Tue, 29 May 2018 13:28:01 GMT

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,

Re: how to convert a date ddmmyyn8 to ddmmyy10.

Kurt_Bremser — Tue, 29 May 2018 13:32:10 GMT

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

Re: how to convert a date ddmmyyn8 to ddmmyy10.

alepage — Tue, 29 May 2018 14:06:23 GMT

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;

Re: how to convert a date ddmmyyn8 to ddmmyy10.

Kurt_Bremser — Wed, 30 May 2018 07:44:08 GMT

@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.

Re: how to convert a date ddmmyyn8 to ddmmyy10.

alepage — Wed, 30 May 2018 15:10:14 GMT

Thanks a lot for your Help Kurt

Best Regards