Maxim 28: Macro Variables Need No Formats.
Change your SQL:
PROC SQL noprint;
SELECT
CURRENT_BEGIN_WEEK format=5.
INTO: CURRENT_BEGIN_WEEK
FROM TABLE_A
WHERE ORDER = 38;
quit;
and you can use ¤t_begin_week without any quotes and trailing d.
If you need to work with a datetime value, increase the format to accommodate all digits.
... View more