Hi ,
I would like a date one day away from the value in a datetime field. My new field is getting created with one day subtracted but all of the times are not preserved. They all get set to 00:00:00.
newdt2=intnx('dtday',datetime(),-1) ;
or
newdt1=intnx('dtday',mydatetimefield,-1) ;
What am I doing wrong?
Thanks
Lee
You are leaving off one parameter, namely 's', to keep the time the same. i.e.,
newdt2=intnx('dtday',datetime(),-1,'s') ;
You are doing nothing wrong. Check the "alignment" documentation for intnx.
The "old fashioned" way to subtract one day from a datetime variable is to simply subtract 1 day's worth of seconds.
newdt = olddt - 24*60*60;
Doc Muhlbaier
Duke
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.