topic Re: Need Date Format like YYYYMMDDHH for the previous hour in SAS Programming

Need Date Format like YYYYMMDDHH for the previous hour

o_p — Thu, 23 Oct 2014 19:43:53 GMT

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 — Thu, 23 Oct 2014 20:59:39 GMT

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 — Thu, 23 Oct 2014 21:38:10 GMT

Thanks Bruno.

This is definitely what I was looking for.

Regards,

Olp