I created a file in access with a date/time in access 2007. I changed the input mask and format to read short date. When I upload to sas it still comes in as a full date/time field. Is there a way to either force sas to accept the date as a short date or is there a script I need in sas to change it from a date time to a short date (ie 04MAY2002:00:00:00 should be 05/04/2002)
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.