Given OP query, Calendar_Month is a string. That's why the INPUT function is called. But the MONYY informat always returns the first of the month. Also, the documentation for the IN operator in SQL is clear: the parentheses must enclose a sequence of CONSTANTS or a query. Thus the condition can be simply written: WHERE INPUT(Calendar_Month, MONYY8.) IN ('01OCT2011'd, '01DEC2011'd); PG ... View more

You can do it ,just add a dataset option . But I am not sure whether JDBC will take care of it. Or if your table has already has a column like : 1 2 3 4 5 6 7 8 9 10 ...........  to mark it from smallest to biggest. Then that would be more easy. proc sql; select distinct weight,(select count(*) from         (select distinct weight as w from class(firstobs=100 obs=200)  ) as x          where x.w gt weight) as n from class(firstobs=100 obs=200)   where calculated n in (0 4); quit; Ksharp ... View more

Finally, we got some round about answer to the problem we were facing. Below query fixed the problem to some extent: PROC SQL Query: ============== SELECT MIN(total_cost), MAX(total_cost) FROM (     SELECT distinct total_cost     FROM WORK.product ) WHERE MONOTONIC() BETWEEN 1 AND 5; Note: Using "distinct" in the inner query is working as what we intended with the order by earlier. So avoided the order by and used the MONOTONIC in the outer query. This solved the problem. But again caution if you are using monotonic as read somewhere it is undocumented function of SAS. Gosh, Any other better way is always welcome!! ... View more