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.
... View more