https://communities.sas.com/t5/SAS-Programming/Date-Format/m-p/75857#M16347 I believe there are "import" options where SAS will scan the incoming standard "datetime" variables for a date and assign a SAS DATE formatted variable, rather than a datetime variable. Check the SAS DOC for handling datetime columns, options USEDATE= and SCANTIME=.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Sat, 28 Feb 2009 21:26:41 GMT sbb 2009-02-28T21:26:41Z https://communities.sas.com/t5/SAS-Programming/Date-Format/m-p/75856#M16346 I am just starting to use PC SAS at work and we have linked it to our SQL server so i can see our tables there. My problem is that all of the date fields come over in the following format: 01MAR2009 00:00:00. I know that SQL stores it with the timestamp and programs like Microsoft Access and SQL Server software can some how strip it off and makes the date viewable as mm/dd/yyyy. I was wondering if there was a setting somewhere in PC SAS that can make date fields easier to use instead of me having to format it every damn time. Thank you. Sat, 28 Feb 2009 19:15:36 GMT https://communities.sas.com/t5/SAS-Programming/Date-Format/m-p/75856#M16346 mdkryptoking 2009-02-28T19:15:36Z https://communities.sas.com/t5/SAS-Programming/Date-Format/m-p/75857#M16347 I believe there are "import" options where SAS will scan the incoming standard "datetime" variables for a date and assign a SAS DATE formatted variable, rather than a datetime variable. Check the SAS DOC for handling datetime columns, options USEDATE= and SCANTIME=.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc. Sat, 28 Feb 2009 21:26:41 GMT https://communities.sas.com/t5/SAS-Programming/Date-Format/m-p/75857#M16347 sbb 2009-02-28T21:26:41Z