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 / 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 |
Post New Answer View All Answers
What are the ways in which macro variables can be created in sas programming?
Explain append procedure?
How do you specify the number of iterations and specific condition within a single do loop?
what is null hypothesis? why do you consider that?
What is SAS?
What are the differences between sum function and using “+” operator?
How to specify variables to be processed by the freq procedure?
What are the 3 components in sas programming?
Give some examples where proc report’s defaults are same as proc print’s defaults?
List out some key concept of SAS
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
How do dates work in sas?
What is data _null_?
Why and when do you use proc sql?
what are the benefits of data integration? : Sas-di