proc sql to retrieve 10m rows from Oracle does not finish

[metallon]

Hi,

I run the proc contents on the 1m rows that I managed to load.

Blocking Factor (obs/block) 264
Data Partsize 1310664960

Obersvations: 1000000
Variables: 100
Obs length: 3960
Compressed: No
Sorted: No

Engine: META
membertype: data

server admin said 2.8gb are used up.

[metallon]

We significatly extended the disc space and now its working like a charm. 10m rows take up 8.5GB.