Hi Aaron,   If you're looking for a 'ready made' solution to what you describe, I would refer you to https://datacontroller.io   If you're looking for an 'admin not necessary' approach to building & deploying web apps, you can also consider the SASjs framework - specifically, the 'streaming app' capability.  This compiles a frontend into a series of STPs, obviating the need for a web server (and requisite access rights).   Happy to jump on a call to explain further.   ... View more

I discarded some of the ideas i had earlier. First two steps are for setting the size of the temp arrays. Performance has to be tested.   proc freq data=work.prices noprint order=freq; table product / nopercent out=work.ProductCount(keep=product count) ; run; data _null_; set work.ProductCount(obs=1); call symputx('maxElements', count); run; data want(keep=product tran_date price_date price); if 0 then set work.Transactions; array d[&maxElements.] _temporary_; array p[&maxElements.] _temporary_; call missing(of d[*]); call missing(of p[*]); do i = 1 to dim(d) until (last.product); set work.Prices; by product; d[i] = price_date; p[i] = price; end; c = i; s = 1; do until(last.product); set work.Transactions; by product; do i = s to c while(d[i] <= tran_date); end; i = i-1; s = i; price_date = d[i]; price = p[i]; output; end; run; ... View more