Hello, I'd like to build a new variable based on a new existing macro variable &simuldate how has a format date9. The new variable should be the business day of the last month and has a datetime format . I've tried the code below data _null_;
call symputx('datdt',put(intnx('WEEKDAY', intnx('MONTH', &simuldate, -1, 'END'), 0),DATE9.));
run; this works But when tried to convert the date in datetime format: data _null_;
call symputx('datdt_m', put(dhms('&datdt'D,0,0,0),datetime.));
run; I got ERROR: Invalid date/time/datetime constant '&datdt'D. can anyone help. Thank you Nihal
... View more