proc freq for huge data

[abdullala]

I got a huge data of over 100 million records, 2 variables a and b. I need to do
proc freq;
table a*b;
run;

I got:
ERROR: The requested table is too large to process.

any suggestions to beat this beast? many thanks!

[LinusH]

I think FREQ try to build this in physical memory.
On way of doing this is to use SQL, which will use utility files on disk during sort/summarization.
Or you could try a divide and conquer strategi...

/Linus