topic Re: SAS B8601DZ35. Format to Date in SAS Programming

SAS B8601DZ35. Format to Date

MarcBoh — Sat, 07 Jul 2018 05:49:26 GMT

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

Re: SAS B8601DZ35. Format to Date

PeterClemmensen — Sat, 07 Jul 2018 06:16:22 GMT

Something like this?

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

Re: SAS B8601DZ35. Format to Date

MarcBoh — Sat, 07 Jul 2018 06:31:09 GMT

Thanks Draycut.

I made it though with:

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

Re: SAS B8601DZ35. Format to Date

ballardw — Mon, 09 Jul 2018 22:37:41 GMT

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;