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

[rakeshvvv]

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

[Reeza · Accepted solution]

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

[DartRodrigo]

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