Hi KurtBremser, Hre's the log: Hi ChrisNZ, Sorry the dataset has 500 millions rows instead. Not sure is this considered huge or not. Anyway, the dataset is compressed but not sorted and not indexed. Here's the log: NOTE: There were 0 observations read from the data set ILIN.ACMVPF. WHERE (trandate='18OCT2020'D) and (orgtrcde in ('T679', 'TA69') or batctrcde in ('T679', 'TA69')); NOTE: The data set WORK.TEST has 0 observations and 59 variables. NOTE: DATA statement used (Total process time): real time 24:43.62 user cpu time 4:23.93 system cpu time 1:55.64 memory 875.78k OS Memory 20120.00k Timestamp 10/20/2020 07:06:40 PM Step Count 154 Switch Count 2230 Page Faults 123 Page Reclaims 592 Page Swaps 0 Voluntary Context Switches 932839 Involuntary Context Switches 150130 Block Input Operations 336232352 Block Output Operations 144 Observation size is 484928084 It is a native SAS stored on SAN. Server V8: 4 Core , 32gb memory Operating system: Red Hat Linux Enterprise 6.3 ... View more

Hi ChrisNZ, Sorry the dataset has 500 millions rows instead. Not sure is this considered huge or not. Anyway, the dataset is compressed but not sorted and not indexed. Here's the log: NOTE: There were 0 observations read from the data set ILIN.ACMVPF. WHERE (trandate='18OCT2020'D) and (orgtrcde in ('T679', 'TA69') or batctrcde in ('T679', 'TA69')); NOTE: The data set WORK.TEST has 0 observations and 59 variables. NOTE: DATA statement used (Total process time): real time 24:43.62 user cpu time 4:23.93 system cpu time 1:55.64 memory 875.78k OS Memory 20120.00k Timestamp 10/20/2020 07:06:40 PM Step Count 154 Switch Count 2230 Page Faults 123 Page Reclaims 592 Page Swaps 0 Voluntary Context Switches 932839 Involuntary Context Switches 150130 Block Input Operations 336232352 Block Output Operations 144 ... View more