Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 5646 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Describe 5 ways to do a “table lookup” in SAS?
What is the role of unrestrictive users? : sas-grid-administration
What is SAS?
what is metadata? : Sas-bi
What are the difficulties u faced while doing vital signs table or dataset?
What is the sas data set? : sas-grid-administration
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
what does the run statement do? : Sas programming
What is the differnce between SDTM 3.1.2 to 3.1.1 version
explain the function of substr in sas? : Sas-administrator
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
What are the ways to do a “table lookup” in sas?
How can you create a macro variable with in data step? : sas-macro
Difference between sum function and using “+” operator?
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
