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 informats in sas? : Sas-administrator
What are the new features included in the new version of SAS Programming Language?
What is connection profile? : sas-grid-administration
how do you want missing values handled? : Sas programming
Mention what is PROC in SAS?
What is the use of the %include statement?
what is information maps?
what is the difference between floor and ceil functions in sas? : Sas-administrator
is data integration and etl programming is same? : Sas-di
In proc transpose and data step with arrays which one you pick?
How do you debug and test your SAS programs?
Differentiate between ceil and floor functions.
What was the last computer book you purchased? Why?
Describe 5 ways to do a “table lookup” in SAS?
Enlist the syntax rules followed in sas statements.