And when you use SAS dates remember to ensure they are formatted (not just as a number) when passed to a client system (like any DBMS). Native teradata has almost no tools I could find to help convert 'number of days since 1960' back to an understandable date. (only with a look-up table written by SAS was teradata able to use the internal SAS date) Peter