InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 19:09:05 GMT20http://www.teradata.com/teradataforum/Topic11286-1-1.aspxAs 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,PeterWed, 23 Apr 2008 00:26:09 GMTpjroutledge