I would like to know the most efficient way to get the min and max of a subset of a column. I realize could do a select where(), and actually use the table subset function, and summarize, but I need the script to loop through thousands of columns (unique criteria per column) and I think opening / closing tables via subset is too slow.
I was hoping to do a select where() to select the rows, and then somehow get the selected data into a list, and return the min and max of the list. I've tried several things but haven't had any success. Any ideas?
Here's a simple test script. In this case I would want to return the min = 66 and the max = 70.