topic Re: Using PROC SQL to run a query for Date column in a table in SAS Procedures

Using PROC SQL to run a query for Date column in a table

deleted_user — Thu, 19 Nov 2009 19:52:34 GMT

Hi,
I'm trying to run a query to check the SourceTime format (15JUL2009:16:12:07) is after 16:00 then create new column as AdjustedTime (16JUL2009:10:00:00), else AdjustedTime=SourceTime.

Appreciate for your assistance.

Thanks,

Re: Using PROC SQL to run a query for Date column in a table

Flip — Thu, 19 Nov 2009 20:19:22 GMT

look at the TIMEPART() function

Re: Using PROC SQL to run a query for Date column in a table

Flip — Thu, 19 Nov 2009 20:19:28 GMT

look at the TIMEPART() function

Re: Using PROC SQL to run a query for Date column in a table

Flip — Thu, 19 Nov 2009 20:19:35 GMT

look at the TIMEPART() function

Re: Using PROC SQL to run a query for Date column in a table

Doc_Duke — Thu, 19 Nov 2009 21:26:23 GMT

Look at the documentation for the TIMEPART function. The CASE clause will allow you to do the decision breaks.

Something like
timepart(sourcetime) > '16:00:00'T
will establish the criteria.

Re: Using PROC SQL to run a query for Date column in a table

Doc_Duke — Thu, 19 Nov 2009 21:26:58 GMT

Look at the documentation for the TIMEPART function. The CASE clause will allow you to do the decision breaks.

Something like
timepart(sourcetime) > '16:00:00'T
will establish the criteria.

Re: Using PROC SQL to run a query for Date column in a table

Doc_Duke — Thu, 19 Nov 2009 21:27:18 GMT

Look at the documentation for the TIMEPART function. The CASE clause will allow you to do the decision breaks.

Something like
timepart(sourcetime) > '16:00:00'T
will establish the criteria.

Re: Using PROC SQL to run a query for Date column in a table

Doc_Duke — Thu, 19 Nov 2009 21:27:35 GMT

Look at the documentation for the TIMEPART function. The CASE clause will allow you to do the decision breaks.

Something like
timepart(sourcetime) > '16:00:00'T
will establish the criteria.

Re: Using PROC SQL to run a query for Date column in a table

Doc_Duke — Thu, 19 Nov 2009 21:27:56 GMT

Look at the documentation for the TIMEPART function. The CASE clause will allow you to do the decision breaks.

Something like
timepart(sourcetime) GT '16:00:00'T
will establish the criteria.

Re: Using PROC SQL to run a query for Date column in a table

milts — Fri, 20 Nov 2009 00:45:27 GMT

Hi hope this is the solution you're looking for

proc sql;

select
case when
timepart(sourcetime) > '16:00:00't then
input(put(datepart(sourcetime)+1,date9.) || ' ' || '10:00:00',datetime.)
else
sourcetime
end
as adjustedtime format = datetime.
from table

quit;

There are probably other ways but this is the one that i came up with

Regards,
Milton

Re: Using PROC SQL to run a query for Date column in a table

milts — Fri, 20 Nov 2009 00:46:44 GMT

Re: Using PROC SQL to run a query for Date column in a table

milts — Fri, 20 Nov 2009 00:46:44 GMT

Re: Using PROC SQL to run a query for Date column in a table

milts — Fri, 20 Nov 2009 00:47:28 GMT

Re: Using PROC SQL to run a query for Date column in a table

milts — Fri, 20 Nov 2009 00:47:29 GMT

Re: Using PROC SQL to run a query for Date column in a table

milts — Fri, 20 Nov 2009 00:48:24 GMT

Re: Using PROC SQL to run a query for Date column in a table

milts — Fri, 20 Nov 2009 00:48:25 GMT

Re: Using PROC SQL to run a query for Date column in a table

milts — Fri, 20 Nov 2009 00:49:01 GMT

Re: Using PROC SQL to run a query for Date column in a table

milts — Fri, 20 Nov 2009 00:49:01 GMT

Re: Using PROC SQL to run a query for Date column in a table

milts — Fri, 20 Nov 2009 00:49:44 GMT

Re: Using PROC SQL to run a query for Date column in a table

milts — Fri, 20 Nov 2009 00:49:45 GMT