I am receiving the below warning/error: WARNING: Apparent symbolic reference startdate not resolved. ERROR: Invalid date/time/datetime constant "&startdate"d. ERROR: Invalid date/time/datetime constant "&enddate"d. This is my exact code: %macro datebound; %let today=%sysfunc(today(),date9.); %let day=%sysfunc(weekday("&today"d)); %if &day=2 %then %do; %let startdate=%sysfunc(intnx(DAY,"&today"d,-3),date9.); %let enddate=%sysfunc(intnx(DAY,"&today"d,-1),date9.); %end; %else %do; %let startdate=%sysfunc(intnx(DAY,"&today"d,-1),date9.); %let enddate=%sysfunc(intnx(DAY,"&today"d,-1),date9.); %end; %put startdate= &startdate enddate= &enddate; %mend; %datebound; PROC SQL; CREATE TABLE POLICY AS SELECT A.datebound, A.Customer_ID, A.InsFirstLast, C.FirstName, C.LastName, A.email, A.PlanCode, A.Policy, DATEPART(A.DateBound) AS FeedbackDate FORMAT MMDDYY10., A.DistributionChannel, A.Carrier, A.PlanType, B.Supervisor, B.Name FROM CorpAn.DirectNBPolicies A LEFT JOIN CorpAn.Employee B ON A.I_EmpID = B.I_EmpID LEFT JOIN AgCube.tbl_CustomerRelationShip C ON UPPER(A.InsFirstLast) = UPPER(C.FullName) WHERE "&startdate"d<= datebound <="&enddate"d AND A.MediaCode NE '30' AND A.email LIKE ('%@%') ; QUIT;
... View more