efi88: As has already been stated, the retain statement should be a big help.   However, it appears that you have an error in your  'wanted data'.  For name 'caca', according to your specified formula, the result should be 53 (65-12), not 44 as shown.   Best Wishes. ... View more

You mentioned that your professor provided a work-around. Would you mind posting it for the rest of the community? Thanks. ... View more

Julie, a value of 21639 converts to day 03/31/2019. It appears that your "%let str" statement might need a value of 6 in the outer intnx call which will provide a value of 21914 and will resolve to 12/31/2019.   My code isn't pretty, but I think it illustrates the concept adequately.   options symbolgen; %let str1=intnx('quarter',intnx('quarter', '01JAN2017'd, 5, "sameday"), 3, "end"); %let str2=intnx('quarter',intnx('quarter', '01JAN2017'd, 5, "sameday"), 6, "end");   data _null_; call symputx('dt1', &str1,'G'); call symputx('dt2', &str2,'G'); run;   data temp; format mydt1 mydt2 mmddyy10.; mydt1=&dt1; mydt2=&dt2; run;   %put _all_;   proc print;run;     Obs         mydt1            mydt2 1 03/31/2019 12/31/2019 ... View more