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
Describe the ways in which you can create macro variables?
What is the basic syntax style in SAS?
How to convert a numeric variable to a character variable?
Give e an example of..
What is the difference between class statement and by statement in proc means?
What is by-group processing?
hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?
How do you test for missing values?
What are the table names in oracle database...?
how are numeric and character missing values represented internally? : Sas programming
is data integration and etl programming is same? : Sas-di
What is the difference between input and infile statement?
how do you debug and test your sas programs? : Sas programming
List out some key concept of SAS
what has been your most common programming mistake? : Sas programming