Convert Macro variable datetime into date9

[sarahzhou]

Hi,

I have a macro variable from proc sql select into:DATA_LOAD_DT, which is "20OCT2022:19:41:27.933" in the result.

SYMBOLGEN: Macro variable DATA_LOAD_DT resolves to 20OCT2022:19:41:27.933

How can I convert this Marcro variable DATA_LOAD_DT into "20OCT2022"?

I have tried:

%let dl_date=%sysfunc(put(datepart("&DATA_LOAD_DT."D), date.9.);
%put dl_date;

error: The PUT function referenced in the %SYSFUNC or %QSYSFUNC macro function is not found.

Please advise.

Thank you!