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
- 4385 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / satheesh
you can use index statement,
proc sql;
create index indexname on Tablename(Variable or Columnname);
quit;
the above code is equivalent to sort.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
WHAT DOES A SAS SPECIFICATION DOCUMENT SDS CONTAIN ?
what is the difference between x=substr(name,1,2); and substr(name,1,2)='x';
Do you need to know if there are any missing values?
what is the use of LRECL option.
When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?
How could you generate test data with no input data?
how do the in= variables improve the capability of a merge? : Sas programming
What are exact SAS Base contents..?N what r SAS Tools..?
i am importing large data from oracle to work library. in log there is a error message worklibrary space is not enough. then how to import the data safely to sas environment.
Name statements that are recognized at compile time only?
Mention sas system options to debug sas macros.
what is Global Symbol table and Local symbol table?
Teradata 
