Trying to replicate MAX function in SAS

[jmenche]

Apologies if this is out of scope (feel free to delete, but a lot of things that are easy in Excel are not in a database language. I have a very large dataset (about 1B records so VBA is not an option) that I am working with in SAS. I am trying to do a rolling MAX in a data step and do not know enough SAS to get it done.

Does anyone have any experience with SAS to give me a pointer or two?

Jeff

[Kenneth Hobs]

Right, this should be a SAS forum.

It has been too many years since I last used it I guess. I don't know what the data step method would involve. Proc SQL Max() would be another method I suppose. e.g. https://communities.sas.com/t5/forum...on=false&q=max