All Forums UDA
pj.routledge 7 posts Joined 04/08
23 Apr 2008
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

You must sign in to leave a comment.