topic Re: How to remove the seconds from datetime20 in SAS Programming

How to remove the seconds from datetime20

Gil_ — Thu, 20 Apr 2017 19:50:11 GMT

I have a col name create which is a datetime20
The data looks like this 13apr2017:00:00:02
I need the data to look like this
13apr2017:00:00
Thanks for assistance

Re: How to remove the seconds from datetime20

ballardw — Thu, 20 Apr 2017 19:55:02 GMT

Do you want to actually remove the seconds or just not display them?

data junk;
   x='13apr2017:00:00:02'dt;
   y= round(x,60);/* changes the value*/
   put y= datetime20. ;
  /* or just use a different format to suppress display of the seconds*/
   put x= datetime13.; 
run;

Re: How to remove the seconds from datetime20

Gil_ — Thu, 20 Apr 2017 20:25:46 GMT

Hi I need to remove them

Re: How to remove the seconds from datetime20

ballardw — Thu, 20 Apr 2017 22:25:46 GMT

@Gil_ wrote:
Hi I need to remove them

The use the Round in the example. Since datetime values are actually numbers of seconds rounding to the nearest multiple of 60 rounds to the nearest minute.

Of if you want to truncate to the minute regardless of the number of seconds you could use INTNX:

data _null_;
   x='05Apr2017:12:15:22'dt;
   x = intnx('minute',x,0,'b');
   put x datetime20.;
run;

Re: How to remove the seconds from datetime20

Gil_ — Thu, 20 Apr 2017 22:36:49 GMT

In the log it shows the sec removed but when I open table x=1807660800. How can I show datetime20?

Re: How to remove the seconds from datetime20

ChrisNZ — Fri, 21 Apr 2017 02:31:45 GMT

data TEST;
   x='05Apr2017:12:15:22'dt;
   x = intnx('minute',x,0,'b');
   format x datetime20.;
   put x=;
run;

Re: How to remove the seconds from datetime20

Gil_ — Fri, 21 Apr 2017 15:36:07 GMT

I'm getting an error message ... the table is located in a library named Ecms . When I refer the table I get this message
THE ORACLE TABLE CP_EVENT HAS BEEN OPENED FOR OUTPUT. THIS TABLE ALREADY EXISTS
OR THERE IS A NAME CONFLICT WITH AN EXISTING OBJECT. THIS TABLE WILL NOT BE REPLACED . THIS ENGINE DOES NOT SUPPORT REPLACE OPTION

HERE IS THE SCRIPT
DATA ECMS.CP_EVENT;
Set ecms.cp_event;
X=create;
X=intnx ('minute',x,0,'b");
Put x datetime20.
Rum;

Re: How to remove the seconds from datetime20

ballardw — Fri, 21 Apr 2017 17:09:56 GMT

Oracle unfortunately uses different behaviors and I don't work with Oracle so can't help there.

Re: How to remove the seconds from datetime20

Gil_ — Fri, 21 Apr 2017 17:23:19 GMT

Ok thanks for assistance

Re: How to remove the seconds from datetime20

ChrisNZ — Fri, 21 Apr 2017 21:58:01 GMT

You need to use proc sql and an update statement as you replacing in the same table