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
- 5412 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
What is the difference between class statement and by statement in proc means?
how to change the execute of macro
How sas treats the dsd delimiters?
how does sas handle missing values in a merge? : Sas programming
How do you connect the desktop application to metadata server? : sas-grid-administration
What are all the problems you faced while validating tables and reports?
How does the internal authentication work in sas? : sas-grid-administration
How to limit decimal places for variable using proc means?
How can sas program be validated?
Which are the statements whose placement in the data step is critical?
What are the difficulties u faced while doing vital signs table or dataset?
How would you define the end of a macro?
List down the reasons for choosing sas over other data analytics tools.
what are the types of interactive display types? : Sas-bi
Give e an example of..
