Need Date Format like YYYYMMDDHH for the previous hour

[o_p]

Hi All,

I want to create a variable which shows the previous hour.

The format of this variable will be YYYYMMDDHH. --> ($CHAR10.)

Assume that; now it is 2014102322, and I want to create my variable with 2014102321 which means it is one hour before the current time.

If it is 2014102400 then the value should be 2014102323.

How can I code that?

Thanks,

Onuralp

[BrunoMueller · Accepted solution]

you can create your own datetime format to get the what you want. The INTNX function can be used to add or subtract datetime intervals, see sample

below:

proc format;

  picture xyyyymmddhh (default=10)

    low - high = '%Y%m%0d%0H' (datatype=datetime)

  ;

run;

data test;

  now = datetime();

  length now_c10 $ 10;

  now_c10 = put(now, xyyyymmddhh.);

  now1h = intnx("dthour", now, -1);

  now_c101h = put(now1h, xyyyymmddhh.);

  format now datetime22.3;

run;

[o_p]

Thanks Bruno.

This is definitely what I was looking for.

Regards,

Olp