Trying to create a BigQuery table from a SAS^® data set might result in a column being incorrectly created as a TIMESTAMP data type rather than the expected DATETIME data type when the following are true:

• You are running one of the following releases of SAS^® or cadences of SAS^® Viya^®
  • SAS^® 9.4M8 (TS1M8) with Hot Fix M7Z014 or later
  • SAS^® 9.4M9 (TS1M9) with Hot Fix R6L001
  • SAS^® Viya^® Platform Stable 2025.01
  • SAS^® Viya^® Platform LTS 2025.03
• The SAS column contains a DATETIME or DATEAMPM format.
• You are not using explicit pass-through facility.

See SAS Note 67420, which introduced the original data type change from TIMESTAMP to DATETIME.

Workaround

To work around this issue, create the BigQuery table with the correct data types using explicit pass-through and then use the SQL or APPEND procedure to insert the data from the SAS data set into the existing BigQuery table.