Using SAS Where clause in Oracle

EEng — Wed, 18 Jul 2018 13:58:43 GMT

Hello,

I'm trying to get the max date in the prior month from an Oracle table using SAS.

%let tday = %sysfunc(today());


proc means data=Oracle_Table noprint;
	 where fin_metric_id in(6,8) and (intnx('month',&tday,-1,'begin')<=input(put(dt_id,z8.),yymmdd8.)<=intnx('month',&tday,-1,'end'));
	 var dt_id;
	 output out=maxdatei max=alt_inv_dt;
run;

I am getting the correct data from this code but I get this warning message that I want to eliminate.

WARNING: The WHERE clause contains SAS-specific syntax that cannot be passed to the DBMS.

WARNING: SQL generation was not performed because the WHERE clause could not be created.

Not sure if it likes the Begin and End in my INTNX function.

Thanks

Re: Using SAS Where clause in Oracle

LinusH — Wed, 18 Jul 2018 15:21:00 GMT

No, it doesn't like the INTNX function as such.
See here for supported functions:
http://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.3&docsetId=acreldb&docsetTarget=p0f64yzzxbsg8un1uwgstc6fivjd.htm&locale=sv
But can't see anything that would stop you to use it prior to the PROC using %sysfunc.

topic Using SAS Where clause in Oracle in SAS Programming

Using SAS Where clause in Oracle

Re: Using SAS Where clause in Oracle