Pass a SAS date parameter to Teradata macro using explicit SQL

UDA
Highlighted
Enthusiast

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.

Will appreciate any help and/or pointers.

Regards,

Peter