topic Re: Function DATEPART requires a numeric expression as argument 1. in SAS Programming

Function DATEPART requires a numeric expression as argument 1.

goms — Mon, 27 Jun 2016 13:22:00 GMT

Hi,

Below query gives an error Function DATEPART requires a numeric expression as argument 1.

proc sql;

create table sample as
select

identifier,
serial,
node,
nodealias,
manager,
agent,
alertgroup,
alertkey,
summary,
location,
class,
poll,
type,
tally,
severity,
owneruid,
ownergid,
acknowledged,
put (datepart(src_lastmodified),yymmdd10.)||" "||put(timepart(src_lastmodified),time9.1) as src_lastmodified
from test.sample1;
quit;

Re: Function DATEPART requires a numeric expression as argument 1.

LinusH — Mon, 27 Jun 2016 13:27:49 GMT

So what data type is src_lastmodified?

Re: Function DATEPART requires a numeric expression as argument 1.

goms — Mon, 27 Jun 2016 13:29:44 GMT

Char type

Re: Function DATEPART requires a numeric expression as argument 1.

Oligolas — Mon, 27 Jun 2016 13:38:26 GMT

You need to convert the character dates to numeric for using datepart and timepart function as in this example:

data sample1;
   src_lastmodified=put(datetime(),is8601dt.);
run;

proc sql;
   select
   put(datepart(input(src_lastmodified,is8601dt.)),yymmdd10.)
   ||" "
   ||put(timepart(input(src_lastmodified,is8601dt.)),time9.1) as src_lastmodified
   from sample1;
quit;

Re: Function DATEPART requires a numeric expression as argument 1.

goms — Tue, 28 Jun 2016 12:27:44 GMT

Hi ,

Thanks for your reply. While executing the below query it returns missing value (.)

proc sql;
select
put(datepart(input(src_lastmodified,is8601dt.)),yymmdd10.)
||" "
||put(timepart(input(src_lastmodified,is8601dt.)),time9.1) as src_lastmodified
from test.sample1;
quit;

Date format needs to changed from

20160531 00:04:37 to 2016-05-31 00:04:37