Step 1: write code (without any macro function at all) that successfully converts one variable in one dataset. Once you have that working, replace variable and/or dataset names with macro variables and set those before the step. Once that works, wrap it in a macro where you supply the macro variables as parameters.
Everything else is just inviting pain for yourself.
I looks like you are trying to do something like this:
%let oldname= datetime_variable;
%let newname= date_variable;
data new ;
set old;
&newname = datepart(&oldname);
format &newname date9.;
run;
Since both a DATE and a DATETIME variable are numeric you could set both macro variables to the same dataset variable.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.