topic Re: INTCK + DATEPART in SAS Procedures

INTCK + DATEPART

pkonopnicki — Tue, 08 Nov 2016 16:46:06 GMT

Hi guys,

I'm trying to use both INTCK and DATEPART function, but it gives me an error:

ERROR 22-322: Syntax error, expecting one of the following: a name, *.

This is my code:

PROC SQL;
CREATE TABLE Client_month AS
SELECT DISTINCT

t1.ID,
INTCK('month', today(), datepart(t1.client_datetime, DATE9.)) as MONTHS
FROM Customers t1
QUIT;

I'm trying to obtain a range in months between today() date and a date, that is in datetime format, therefore I'm trying to use datepart format date9 to get it in normal date format.

I can't figure it out. Could you please help?

thanks!

Re: INTCK + DATEPART

LinusH — Tue, 08 Nov 2016 16:46:01 GMT

Datepart doesn't use a format as an argument.

Re: INTCK + DATEPART

pkonopnicki — Tue, 08 Nov 2016 16:55:51 GMT

Danke schon

Re: INTCK + DATEPART

PGStats — Tue, 08 Nov 2016 16:59:27 GMT

Use

INTCK('dtmonth', t1.client_datetime, datetime()) as MONTHS,

INTCK("MONTH", datepart(client_datetime), today()) as MONTHS,