🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

How do I configure regional date formats?

User: "Daniel Batey"
Daniel Batey
Altair Community Member
Updated by Daniel Batey

We are in the process of moving to a new server and have installed the latest 2023 version of Analytics Workbench.  We are testing some SAS scripts that worked on our old server and have encountered an issue with dates.  When I run a program that uses proc import to read in an Excel file, dates are defaulting to a string in mm/dd/yy format but when my colleague runs exactly the same program it defaults to dd/mm/yy as expected.  On our old server both of us run the same code and it correctly loads as dd/mm/yy.  

We have checked our server and it is set to GB date format.  And when I check my user details on office.com it is showing as GB default date format.  

Where is this setting being picked up from and how can I change it?  I don't really want this to be user specific either for obvious reasons - the same code resulting in two different results is not good at all!

Thanks

Daniel

Find more posts tagged with

Analytics Workbench
English
v2023.0
Quick Links