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
- 5402 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 data _null_?
How will you generate test data with no input data?
Briefly explain input and put function?
Explain the special input delimiters used in sas programming.
do you prefer proc report or proc tabulate? Why? : Sas programming
what can you learn from the sas log when debugging? : Sas programming
What areas of SAS are you most interested in?
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
Describe a time when you were really stuck on a problem and how you solved it?
What are the different servers in sas? : sas-grid-administration
Mention what is the difference between nodupkey and nodup options?
why a stop statement is needed for the point= option on a set statement?
what is sas enterprise intelligence architecture? : Sas-bi
What is the difference between where and if statement?
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
