Please explain what you are trying to do. Please explain what your grouping variable(s) is. Post a small sample set of data (in the form of a data step that we can run to re-create it) and what result you are trying to get.
Also is there any reason you need to use SQL instead of just writing normal SAS code?
... View more