Hi,   Suppose I have two tables: Transactions: PRODUCT TRAN_DATE 1       05JUL19 1       07JUL19 1       01AUG19 2       04APR19 2       21MAY19 2       16JUN19   Prices: PRODUCT PRICE_DATE PRICE 1       01JAN19    10 1       06JUL19    11 2       01JAN19    1000 2       01MAY19    1100 2       01AUG19    1200   I want the price in effect as of the transaction date. So the price that corresponds to the maximum price_date that is less than or equal to the tran_date. What is the correct SQL to return a table like below? PRODUCT TRAN_DATE PRICE_DATE PRICE 1       05JUL19   01JAN19    10 1       07JUL19   06JUL19    11 1       01AUG19   06JUL19    11 2       04APR19   01JAN19    1000 2       21MAY19   01MAY19    1100 2       16JUN19   01MAY19    1100   Thanks, Aaron ... View more

Hello,   I have a couple stored processes to fetch a SAS dataset and then display it on the web in a jqGrid object.  My jqGrid example allows for edits, adds, and deletes.  I'd like to pass these edits, adds, and deletes back to my SAS dataset.  Does anyone know how to accomplish this?   I suspect I may need to change the editurl option and use another stored process?   I hope to use the boemska tools once I get more admin privileges.   Thanks, Aaron ... View more