topic Re: Extracting date, month, year and time from a datetime variable in SAS Programming

Extracting date, month, year and time from a datetime variable

rakeshvvv — Thu, 25 Feb 2016 19:02:36 GMT

Hi Everyone,

Can some one help me with extracting DAY, MONTH, YEAR and Time from the below format....

2015-08-27T 8:36:00

2014-09-30T14:45:00

The output should look like this…

STDTC ST_Y ST_M ST_D ST_TM

2015-08-27T 8:36:00 2015 8 27 08:36

2014-09-30T14:45:00 2014 9 30 14:45

Thanks in advance

Rakesh

Re: Extracting date, month, year and time from a datetime variable

Reeza — Thu, 25 Feb 2016 19:03:34 GMT

1. Datepart() function to extract date

2. Timepart() function to extract time

3. Year(), Month(), Day() function to extract date components - reference variable from #1

Re: Extracting date, month, year and time from a datetime variable

DartRodrigo — Thu, 25 Feb 2016 19:45:36 GMT

Hi mate,

Try this. Not the best option but works:

data dt;
  date="2015-08-27T 8:36:00 ";
run;

data dt2;
   set dt;
   ST_Y  = input(scan(date,1,"-"),Year.);
   ST_M  = input(scan(date,2,"-"),month.);
   ST_D  = input(scan(scan(date,1,"T"),3,"-"),day.);
   ST_TM = input(scan(date,2,"T"),nltime10.);
   format ST_TM nltime10.;
run;

Hope this helps