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)
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Datetime in sas when uploading from access 1
- Thread starter sap1958
- Start date
-
1
- #2
- Thread starter
- #3
data lib.MyTable1;
set lib.MyTable;
Billed_Dt = datepart(BILLED_DATE);
format Bill_Dt mmddyy10.;
run;
Now I get what appears to be a sas system date or something
(ie 04MAY2002:00:00:00 becomes 15464, 23APR2002:00:00:00 becomes 15453 ) I attempted to address using a format statement but no luck
set lib.MyTable;
Billed_Dt = datepart(BILLED_DATE);
format Bill_Dt mmddyy10.;
run;
Now I get what appears to be a sas system date or something
(ie 04MAY2002:00:00:00 becomes 15464, 23APR2002:00:00:00 becomes 15453 ) I attempted to address using a format statement but no luck
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question