I might be missing something here, but I think the problem is that you are forcing the format date9. in your data processing. Long story short, export and import are fine. Your data step has the wrong format. Change it, problem solved! And, indeed, in the SAS datasets, there is no formatting, just a numeric value. Formats are used to read and write those values. In short, in short, just a representation of a natural number. Please give a look to the documentation: https://documentation.sas.com/doc/en/vdmmlcdc/8.1/ds2pg/p0bz5detpfj01qn1kz2in7xymkdl.htm "...The following table displays the results of formatting the date March 17, 2012..." DATE9. :19069 —> 17MAR2012 In short, if you use date9. the value 19069 in the dataset will be formated as 17MAR2012, which is what you are experiencing and not desired. When you want to keep the format 01/12/2024, you need to use mmddyy10. I think this was indicated earlier. MMDDYY10. : 19069 —> 03/17/2012 This should resolve any issue, regardless of any undesired difference between the Dev and Prod environments. I suggest to work on the solution you can be in control of (your code), and raise the fact the 2 environments are different to your administrators, without you needing to wait for them.
... View more
