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
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;
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.