I would like to gain some insight into the possibilities available to me. For the past while I've had the opportunity to get better acquainted with psql. However, I find myself now in an environment where SAS and proc sql are the order of the day. I been playing around with the first. and last. constructs in order to obtain window functionality that resembles the over () construct in psql. I've come accross this site SAS(R) 9.4 Intelligence Platform: Middle-Tier Administration Guide, Second Edition In which it looks like I might be able to still use pgadmin (and psql) instead of proc sql. Is there anybody out there that will be able to give me some pointers on this matter either by referring to 1) How I can still setup pgadmin 2) How I can better get to grips with sas to be able to get (something like) window functions working? Thanks in advance for any help / advise.
... View more