What you have found is the midtier event manager setup/configuration/usage.  It is about monitoring reporting the SAS environment in the Enterpise Intelligence approach by IT staff people. That one is not meant to be used by SAS programmers building SAS applications for the business. For programming in SAS is doesn't make any sense to want to stick on your old postgres approach. The reason is SAS SQL is ANsI-1999 based and postgres is not using the same kind of dialect. The over() in SAS is missing as those functions are the ones supported by the SAS procs. There are no window functions with SAS-sql because of that.  Only when the sas/access to postgres is licensed and installed you can use the special postgres interfaces SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Sixth Edition For some databases (not Progres) it is possible to have an  "in database" processing option activated, it will propagate a window function to the external DBMS and return the results to those SAS procs. Base SAS(R) 9.4 Procedures Guide, Third Edition (see the list of DBMS systems).    ... View more