Export 01/01/60

[BETO]

HI

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

[SASKiwi · Accepted solution]

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;