Help using Base SAS procedures

Export 01/01/60

Accepted Solution Solved
Reply
Regular Contributor
Posts: 240
Accepted Solution

Export 01/01/60

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


Accepted Solutions
Solution
‎09-22-2014 11:15 PM
Super User
Posts: 3,250

Re: Export 01/01/60

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;

View solution in original post


All Replies
Solution
‎09-22-2014 11:15 PM
Super User
Posts: 3,250

Re: Export 01/01/60

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;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 168 views
  • 0 likes
  • 2 in conversation