Help using Base SAS procedures

INTCK + DATEPART

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 12
Accepted Solution

INTCK + DATEPART

[ Edited ]

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!

 


Accepted Solutions
Solution
‎11-08-2016 11:55 AM
Super User
Posts: 5,428

Re: INTCK + DATEPART

Posted in reply to pkonopnicki
Datepart doesn't use a format as an argument.
Data never sleeps

View solution in original post


All Replies
Solution
‎11-08-2016 11:55 AM
Super User
Posts: 5,428

Re: INTCK + DATEPART

Posted in reply to pkonopnicki
Datepart doesn't use a format as an argument.
Data never sleeps
Occasional Contributor
Posts: 12

Re: INTCK + DATEPART

Danke schon
Respected Advisor
Posts: 4,920

Re: INTCK + DATEPART

Posted in reply to pkonopnicki

Use

 

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

or

 

INTCK("MONTH", datepart(client_datetime), today()) as MONTHS,  
PG
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 313 views
  • 2 likes
  • 3 in conversation