Hi there, I have a piece of code that works if I do this %LET sd = '1Jul2020'd;
PROC SQL;
CREATE TABLE xxx AS SELECT DISTINCT
xxx
FROM
xxx
WHERE
date BETWEEN &sd. AND INTNX('month', &sd., 3, 'same') - 1;
QUIT; But if I do DATA _NULL_;
start_date = MDY(%SUBSTR(&quarter., 6, 1) * 3 - 2, 1, %SUBSTR(&quarter., 1, 4));
CALL SYMPUT('start_date', start_date);
...
RUN; And replace &sd. with &start_date., what passes through PROC SQL is a SAS date and returns incorrect/nil data - how do I turn my newly created start_date variable into something that's useable? I've googled this and tried a few things and can't find anything that I can use unfortunately Thanks for your help
... View more
