Pass a SAS date parameter to Teradata macro using explicit SQL
As per the subject, I'm trying to run a Teradata macro from SAS using explicit SQL pass through. The macro parameter is a date, but the SAS date format and the Teradata date format differ, and I haven't found a way of converting the date parameter.
Here is an excerpt of the SQL I'm trying to run:
insert into mySAStable select * from connection to teradata ( exec mySchema.myMacro (&dateParameter) );
I have found the function SASDATEFMT, but I can't figure out how to use it to convert a parameter and then use the result.
Similarly, I've found the SAS sample code to "Convert a value in the form of MMYY to a SAS date", which works great, but can't figure out how to use it in the context above.