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
- 5523 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
Enlist the syntax rules followed in sas statements.
Which date function advances a date, time or datetime value by a given interval?
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
What is the difference between where and if statement?
What are the applications primarily used by business analyst? : Sas-bi
explain about various caches available in data integrator? : Sas-di
What is the use of function Proc summary?
What are the statements that are executed only?
Explain the main difference between the sas procedures and functions? : Sas-administrator
Explain how merging helps to combine data sets.
What is substr function?
What is the good sas programming practices for processing large data sets?
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
What are the difference between ceil and floor functions in sas?
How does proc sql work?
