Thanks , I might be slow or missing something , I am trying to do that with my below code but it does not resolve.
e.g code :
data example; x="2018/04/03 08:41:37 AM"; y= input(x, anydtdtm32.); format y datetime20.; run;
proc sql;
create table want as
select *, DHMS(CREATE_DATEINCIDENTS,0,0,0) as CREATE_DATEINCIDENTS1 format=mydatetime26.6, DHMS(REPORTED_DATE,0,0,0) as REPORTED_DATE1 format=mydatetime26.6, DHMS(RESPONDED_DATE,0,0,0) as RESPONDED_DATE1 format=mydatetime26.6, DHMS(CLOSED_DATE,0,0,0) as CLOSED_DATE1 format=mydatetime26.6, DHMS(FIRST_DEP_DATE,0,0,0) as FIRST_DEP_DATE1 format=mydatetime26.6, DHMS(LAST_DEP_DATE,0,0,0) as LAST_DEP_DATE1 format=mydatetime26.6, DHMS(Create_Date,0,0,0) as Create_Date1 format=datetime21., DHMS(HandOverRegion,0,0,0) as HandOverRegion1 format=datetime20., DHMS(HandOverFulfilment,0,0,0) as HandOverFulfilment1 format=datetime20., DHMS(FULFILLMENT_CHANGE,0,0,0) as FULFILLMENT_CHANGE1 format=datetime20., DHMS(Modified_Date,0,0,0) as Modified_Date format=datetime20. /* (((Create_Date/60)/60)/24) + '01JAN1970'd as Create_Date_new format mydatetime26.6,*/ /* datepart(Create_Date)+ '01JAN1970'd as date_test format=mydatetime26.6*/
from work.x10_06_18_sla;
run;
The output displays correctly until LAST_DEP_DATE, from Create_Date it does not resolve.
can you please maybe show me what I am doing wrong.
thanks
... View more
