@morrowcode
I don't have an environment with Oracle to run some tests so here just based on documentation.
According to the doc you can read an Oracle Timestamp with Timezone value into SAS but it will get stored as a string in a character variable. You can find this here under section LIBNAME Statement: Default SAS Formats for Oracle Data Types
TIMESTAMP WITH TIMEZONE
$w.
I don't know how this string will actually look like (please share with us if you can) but it's eventually already in the form you need it so you could write it straight to your .csv.
If you need the string converted to a SAS DateTime value then you need to read it into a numerical variable using the appropriate informat. There are Informats and Formats for time offsets. The docu here here might give you a start.
If you just need everything converted to your local SAS Session time then another way to go would be to use explicit pass-through SQL. You then could cast the column to a simple TIMESTAMP column which you then load into SAS. This way Oracle will ensure correct conversion and you'd be getting directly a SAS Datetime column on the SAS side - but you wouldn't have the time offset anymore. As @Tom proposed you could store this information in a 2nd variable, eventually also already created on the Oracle side via explicit pass-through SQL.
To go down such a route here the docu link.
... View more