topic Export 01/01/60 in SAS Procedures

Export 01/01/60

BETO — Tue, 23 Sep 2014 01:37:52 GMT

i have a table that it appends to and access .mdb table. In the Sas table there is a date that is formatted to mmddyy9. when it exports out to the access table it's converts over to a date time formatt 01/01/60 with time added to it ... I would like one to keep it as a date ...any ideas greatly appreciate

Re: Export 01/01/60

SASKiwi — Tue, 23 Sep 2014 03:15:17 GMT

You probably need to convert your SAS date to a SAS datetime before exporting it. You can use the DHMS function for this.

data _null_;

MySASDate = today();

MySASDateTime = dhms(MySASDate, 0, 0, 0);

format MySASDateTime datetime24.;

put MySASDateTime = ;

run;