topic Re: Formatting Hours - adding 3 hours to variable/date in data in SAS Programming

Formatting Hours - adding 3 hours to variable/date in data

sasxii — Wed, 11 Sep 2019 19:55:51 GMT

Hi there,

I have a date format in DATETIME18. and would like to add three hours to it to reflect a timezone.

EX.

12/31/2018 8:13:55 AM will become 12/31/2018 11:13:55 AM in the column for all the variables that fall under that column.

How would you do this? At the moment I have already put my data in and it is listed as data1 with the date column being 'DATE' .

Re: Formatting Hours - adding 3 hours to variable/date in data

PaigeMiller — Wed, 11 Sep 2019 19:59:49 GMT

Three hours is 3*60*60 = 10800 seconds. So you would add 10800 to the date/time variable.

Re: Formatting Hours - adding 3 hours to variable/date in data

sasxii — Wed, 11 Sep 2019 20:02:10 GMT

so would it be DATETIME18. + hours converted to seconds?

Re: Formatting Hours - adding 3 hours to variable/date in data

PaigeMiller — Wed, 11 Sep 2019 20:04:16 GMT

If the variable is named DATE then

date = date + 10800;

Re: Formatting Hours - adding 3 hours to variable/date in data

sasxii — Wed, 11 Sep 2019 20:12:14 GMT

Would I do it in a proc format?

proc format;
DATE = DATE + 10800;
run;

Re: Formatting Hours - adding 3 hours to variable/date in data

PaigeMiller — Wed, 11 Sep 2019 20:15:12 GMT

@sasxii wrote:
Would I do it in a proc format?

proc format;
DATE = DATE + 10800;
run;

This can only be done in a SAS DATA step. It cannot be done in PROC FORMAT.

Re: Formatting Hours - adding 3 hours to variable/date in data

Tom — Wed, 11 Sep 2019 20:32:17 GMT

NOTE: If you have a datetime value it is going to be confusing to refer to it as a DATE. DATE values are stored in number of days and DATETIME and TIME values are stored in number of seconds.

You can use the INTNX() function to change date/time/datetime values by specific intervals.

intnx('hour',datetime_var,3,'same')

You can use time literal to add three hours.

datetime_var + '03:00't

Or you could just add the right number of seconds.

datetime_var + 3*60*60 ;

In terms of reflecting timezone I would assume that you need some type of test of what timezone the current value represents to get the right number of hours added. So perhaps you data step will look something like this.

data want ;
  set have ;
  if timezone='PT' then datetimevar=datetimevar + '03:00't ;
run;

Re: Formatting Hours - adding 3 hours to variable/date in data

Tom — Wed, 11 Sep 2019 20:25:26 GMT

@sasxii wrote:

so would it be DATETIME18. + hours converted to seconds?

That doesn't make much sense.

DATETIME18. is a format specification, like DOLLAR10.2 or BEST12., not an actual datetime value.

Re: Formatting Hours - adding 3 hours to variable/date in data

sasxii — Wed, 11 Sep 2019 20:27:02 GMT

what happens if I the value is not by a specific interval? how would this be done then?

Re: Formatting Hours - adding 3 hours to variable/date in data

ChanceTGardener — Wed, 11 Sep 2019 20:34:01 GMT

Another possibility:

data test;
 /* Recreating your datetime variable */
  have=dhms('31DEC2018'd,8,13,55);

 /* adding 3 hours */
  want=dhms(datepart(have),hour(have)+3,minute(have),second(have));

 format have want dateampm22.;
run;

Re: Formatting Hours - adding 3 hours to variable/date in data

Tom — Wed, 11 Sep 2019 20:35:08 GMT

@sasxii wrote:
what happens if I the value is not by a specific interval? how would this be done then?

Replace 3 in the formula with the name of the variable that has the number of hours you want to change by.

Re: Formatting Hours - adding 3 hours to variable/date in data

ballardw — Wed, 11 Sep 2019 23:26:48 GMT

@PaigeMiller wrote:

@sasxii wrote:
Would I do it in a proc format?

proc format;
DATE = DATE + 10800;
run;

This can only be done in a SAS DATA step. It cannot be done in PROC FORMAT.

Since Proc Format will now allow use of functions from Proc Fcmp a specific value such as adding 10800 seconds or similar could be used in a format. Whether it is a good idea may be questioned for many purposes. The example in the documentation shows creating two formats to convert temperatures from Celsius to Fahrenheit and Fahrenheit to Celsius which do the numeric conversion and show an appropriate C or F at the end.

Re: Formatting Hours - adding 3 hours to variable/date in data

PaigeMiller — Thu, 12 Sep 2019 10:47:41 GMT

@sasxii wrote:
what happens if I the value is not by a specific interval? how would this be done then?

Do you mean sometimes it might be 6 hours instead of 3 hours? The same method would be used.

Re: Formatting Hours - adding 3 hours to variable/date in data

Reeza — Thu, 12 Sep 2019 13:49:06 GMT

next_time = intnx('hours', originalVariable, incrementVariable);

You can use variables in the INTNX() function which seems appropriate.

@sasxii wrote:
what happens if I the value is not by a specific interval? how would this be done then?