Date Transformation

[alexgouv]

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.

[PeterClemmensen]

Welcome to the SAS Communities 🙂

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

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

[alexgouv]

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.

[Cynthia_sas]

Hi:

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

Cynthia

[PeterClemmensen · Accepted solution]

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;

[Ksharp]

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

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