|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/15/2008 4:46:58 PM
Posts: 1,
Visits: 6
|
|
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
|
|
|
|