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
Mention common programming errors committed in sas ?
What is the basic syntax style in SAS?
What is a macro routine?
what is slowly changing dimension? : Sas-di
what is sas application server? : Sas-di
how can you put a "trace" in your program? : Sas programming
What are the difference between ceil and floor functions in sas?
What is the difference between nodupkey and nodup options?
what is hash files in sas and why we are using this one in sas?
How long can a macro variable be? A token? : sas-macro
What is the role of administrative users? : sas-grid-administration
How can I remove header from output data set?
How can you create a macro variable with in data step? : sas-macro
How do you use the do loop if you don’t know how many times you should execute the do loop?
what are the scrubbing procedures in sas? : Sas programming