SAS B8601DZ35. Format to Date

[MarcBoh]

Hi All,

I just downloaded a file where I have the date with time in the format B8601DZ35.  (variable name date_time)

The problem now is that I cannot really work with it. What I need is the date format as YYMMDD10.  (Year-month-day) and the time as Hour:Minute:Second:Millisecond

The function year=year(date_time) etc but does not work.

I also tried :

data want; set have;
format date_time datetime26.;
put _all_ ;
run;

Also no effect. 

How can I extract the individual values of the variable?

Thanks in advance!

Marc

[PeterClemmensen]

Something like this?

data test;
x = "2018-07-07T08:15:09.0325056-05:00";
y = input(x, B8601DZ35.);
format y datetime26.;
put _all_ ;
run;

[MarcBoh · Accepted solution]

Thanks Draycut.

I made it though with:

	 date = datepart(date_time);
 	    format date mmddyy10.;
  	 time = timepart(date_time);  

[ballardw]

If you don't actually need the time part for anything consider:

data test;
x = "2018-07-07T08:15:09.0325056-05:00";
y = input(x, yymmdd10.);
format y yymmdd10.;
run;