topic Re: Date Transformation in SAS Programming

Date Transformation

alexgouv — Tue, 11 Jun 2019 14:15:22 GMT

Hi,

I am trying to change a date to the Friday of that week. For example, if the date is 6/11/2019, I want the new one to be 6/14/2019. It can be created as a new variable or overwrite the old one it does not matter. If it helps, the old date variable is in the MMDDYY10. format.

Re: Date Transformation

PeterClemmensen — Tue, 11 Jun 2019 14:18:38 GMT

Welcome to the SAS Communities 🙂

data _null_;
    date='11jun2019'd;
    newdate=intnx('week.6',date,1);

    put date= mmddyy10. // newdate= mmddyy10.;
run;

Re: Date Transformation

alexgouv — Tue, 11 Jun 2019 14:38:04 GMT

draycut,

Thanks for the quick reply! I should have specified, but if the date is already a Friday I just want it to stay that date. The code you posted is causing Fridays to be displayed with the date of the following Friday.

Re: Date Transformation

Cynthia_sas — Tue, 11 Jun 2019 15:34:25 GMT

Hi:

You just need to test if the original date is a Friday. Like this:

Cynthia

Re: Date Transformation

PeterClemmensen — Tue, 11 Jun 2019 15:58:38 GMT

No problem 🙂

data _null_;
    date='11jun2019'd;
    if weekday(date)=6 then newdate=date;
    else newdate=intnx('week.6',date,1);

    put date= mmddyy10. // newdate= mmddyy10.;
run;

Re: Date Transformation

Ksharp — Wed, 12 Jun 2019 11:53:20 GMT

data _null_;
    date='11jun2019'd;
    newdate=intnx('week.7',date,0,'e');

    put date= mmddyy10. // newdate= mmddyy10.;
run;