topic Re: How can I create a variable with a ddmmmyyy:hh format from a variable with a datetime21.2 format? in SAS Programming

How can I create a variable with a ddmmmyyy:hh format from a variable with a datetime21.2 format?

Kimberley — Tue, 22 May 2012 18:04:33 GMT

I am struggling at finding a way to group observations by date and hour from a variable that is in a datetime21.2 format.

Any ideas? I am hoping this is a very easy question for someone, as I can't seem to find a way to do it (Using SAS 8.2)

Thank you for your help!

Kim

Re: How can I create a variable with a ddmmmyyy:hh format from a variable with a datetime21.2 format?

JasonDiVirgilio — Tue, 22 May 2012 19:01:00 GMT

Something like this?:

data _null_;

mydate=mdy(1,5,2012);

mydatetime=dhms(mydate,10,42,59);

format mydatetime datetime21.2;

put mydatetime=;

mynewvar=put(day(mydate),z2.)||upcase(put(month(mydate),monname3.))||trim(left(year(mydate)))||':'||put(hour(mydatetime),z2.);

put mynewvar=;

run;

...gives....

mydatetime=05JAN2012:10:42:59.00

mynewvar=05JAN2012:10

Re: How can I create a variable with a ddmmmyyy:hh format from a variable with a datetime21.2 format?

ballardw — Tue, 22 May 2012 21:10:08 GMT

Or just assigne the format in procedure wanting the group. Most of the procs will honor the grouping applied by the format.

Try datetime12.

Re: How can I create a variable with a ddmmmyyy:hh format from a variable with a datetime21.2 format?

Kimberley — Wed, 23 May 2012 15:47:20 GMT

Finished *Pulling Out My Hair*, thank you!

Ballardw, I tried doing this first as I though it would be the cleanest way, but it did not seem to work in proc shewart. Thank you for your help!

Jason, Thanks for the code, I used teh essence of it, and made it work. Thank you!

Re: How can I create a variable with a ddmmmyyy:hh format from a variable with a datetime21.2 format?

Ksharp — Thu, 24 May 2012 04:01:22 GMT

I like ballardw 's idea which is my first option.

Try this:

proc format;
picture fmt 
 low-high='%0d%b%Y:%H'(datatype=datetime) ;
run;


data _null_;
  mydate=mdy(1,5,2012);
  mydatetime=dhms(mydate,10,42,59);
  format mydatetime fmt20.;
  put mydatetime=;
run;

Ksharp