data friday; target=today(); do n=1 to 5 while(date < NWKDOM(5, 6, month(target),year(target))); date=NWKDOM(n, 6, month(target),year(target)); output; end; format target date date9.; run; When I run the above code, i got the output as: 07Jan2022 14Jan2022 21Jan2022 28Jan2022 BUT, %macro test; %let target=today(); %do n=1 %to 5 while(date <NWKDOM(5, 6, month(target),year(target))); %let date= NWKDOM(n,6, month(target),year(target)); output; %end; %mend test; When i run the above code with same condition, I got the output as: 07Jan2022 The output I want is: 07Jan2022 14Jan2022 21Jan2022 28Jan2022 Can someone help me to overcome this situation!! I want 4 macro values in a single macro variable. TIA, Joe
... View more