Hi,   I have some large tables that I need to query but sometimes the query takes so long, SAS EG times out or crashes.   I got a list of the Indexes from our IT guys & read up on some ways to improve my query but I think my syntax is wrong.   Below are a couple of examples that just don't run at the moment.   Any tips as to my syntax welcomed.   I read that writing (idxwhere=no) after the table name will stop SAS doing a full table scan.   My error is just a general syntax error so I must have it really wrong.    Thanks for any help.   Select * from Table_a A (idxwhere=no) Inner Join Table_b B on A.ID = B.ID ------------------------------------------ Select * from Table_a A (idxname=Cust_id) Inner Join Table_b B on A.ID = B.ID ... View more

Hi Forum,   I have a dataset that contains a Date Time field.   So I wrote a Proc SQL statement with the below WHERE Clause.   I want to use the 'INTNX' Function to match the Date Time to a MthYr value such as below:   WHERE intnx('month',datepart(c.DATETIME),0,'e') = 'MAY18' ERROR: ORACLE prepare error: ORA-00904: "INTNX": invalid identifier I'm getting an 'Invalid Identifier' Error.   However, if I add a query builder to the existing table and create an expression using the exact same statement, it works?   Can anyone advise why this is so & how I need to write the WHERE clause so it will run?   Thanks ... View more