You need to perform an analysis on a massive dataset by groups, but are unable

You need to perform an analysis on a massive dataset by
groups, but are unable to sort the data due to memory
constraint. How would you accomplish the task?

Question Posted / guest

2 Answers
4396 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

You need to perform an analysis on a massive dataset by groups, but are unable to sort the data du..

Answer / satheesh

you can use index statement,

proc sql;
create index indexname on Tablename(Variable or Columnname);
quit;

the above code is equivalent to sort.

Is This Answer Correct ?

5 Yes

0 No

You need to perform an analysis on a massive dataset by groups, but are unable to sort the data du..

Answer / rock

Before grouping the dataset first compress the dataset
using compress=yes option whicle creation of dataset like

data x(compress=yes reuse=yes);
set y;
run;
proc sql;
select --- do the grouping now

Sure that sorting will take less time. Try this once
Main trick here is we are compressing the unused space in
dataset so the size of the dataset will get reduce.

Is This Answer Correct ?

2 Yes

0 No

Post New Answer