As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Macro DateText

From sasCommunity
Jump to: navigation, search

Macro DateText is on Macro_Loops_with_Dates.

This utility can be used to retrieve information in the associative array of dates.

Log:

1    /*    name: datetext-test.sas
2       *******/
3   %let today = %sysfunc(today());
4   *let today = %sysfunc(mdy(5,1,2013));
5   *let today = %sysevalf('01May2013'd);
6   
7   %put note:
8   %datetext(date = &today
9            ,text = %nrstr(year:&year month:&Month day:&day)
10           );
note: year:2013 month:March day:Thursday
11  
12  %put
13  %datetext(date = %sysfunc(intnx(week,&today,-1,begin))
14           ,text =
15     %nrstr(work.&year-&mm-&dd is %ordinal(&d).of.week &ddd..of.year)
16           );
work.2013-03-17 is 1st.of.week 076.of.year


--Ronald_J._Fehd macro.maven == the radical programmer