The two following code lines, which are taken from a DATA step, need to be rewritten so that they can be used in a macro: %call symput('startdato', %put(intnx('week',today(), -1, 'beginning')+2, nordfde9.)); %call symput('sluttdato', %put(intnx('week',today(), 0, 'beginning')+1, nordfde9.)); At first I figured I might do it like this: %let startdato = %intnx('week',today(), -1, 'beginning') +2; %let sluttdato = %intnx('week',today(), 0, 'beginning') +1; %put(startdato, nordfde9.); %put(sluttdato, nordfde9.); However, apparently that doesn't work. Can someone please advise me on how to resolve this? Thanks. UPDATE: What I need is create a macrovariable that says for example "02oct2012-08oct2012" (if the job was run today). The INTNX-logic works in a DATA step, so that's not a problem. I can write %let week_period = &sysdate.-&sysdate.; to get 10OCT12-10OCT12, but how do I apply the INTNX and formatting properly in DI Studio precode?
... View more