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?
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 where and if statement?
Explain translate function?
Mention few capabilities of sas framework.
What is program data vector (pdv)?
What is the command used to find missing values?
what is sas data set?
What is the role of sas grid administrator? : sas-grid-administration
Which command is used to save logs in the external file?
What is the basic syntax of a sas program?
Explain by-group processing?
What can you learn from the SAS log when debugging?
why a stop statement is needed for the point= option on a set statement?
What is a method to debug and test your SAS program?
Describe crosslist option in tables statement?
What are types of transport files?