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
- 5549 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 can you learn from the sas log when debugging? : Sas programming
Why do we use QUIT commmand for proc datasets and proc sql ???
How do dates work in sas?
Please write codes to merge two datasets and keep every record in the first dataset.
what is factor analysis? : Sas-administrator
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
How would you identify a macro variable? : sas-macro
How do you add a number to a macro variable?
what is star schema? : Sas-di
how can you get the single data set from the library(which has the number of data sets)?
3 Answers Accenture, Deloitte,
what is the use of proc sql? : Sas programming
how could you generate test data with no input data? : Sas programming
Teradata 
