topic Re: Simple Date Informat Question in SAS Programming

Simple Date Informat Question

vinit_correia — Wed, 29 Jun 2016 11:39:40 GMT

i have data in is8601 dt format.

eg:-'2016-09-15T12:40:23'.

i want to calculate number of days from 1960-01-01.

how do i get that

Re: Simple Date Informat Question

Jagadishkatam — Wed, 29 Jun 2016 12:01:55 GMT

data have;
date1='2016-09-15T12:40:23';
date2='1960-01-01';
run;

data want;
set have;
days=intck('day',input(date2,yymmdd10.),datepart(input(date1,is8601dt.)));
run;

Re: Simple Date Informat Question

vinit_correia — Wed, 29 Jun 2016 12:03:27 GMT

thanks ...that was very helpful

Re: Simple Date Informat Question

vinit_correia — Wed, 29 Jun 2016 12:05:39 GMT

wouold it work if there wasnt a T in Date1?

Re: Simple Date Informat Question

Jagadishkatam — Wed, 29 Jun 2016 12:09:34 GMT

Since we used the informat is8601dt, we are expecting a T in the date1. Else it will not work.