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
- 4408 Views
- I also Faced
- E-Mail Answers
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 what is the difference between nodupkey and nodup options?
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
What is the use of %include statement?
how will you locate the sas platform applications? : Sas-bi
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
In proc transpose and data step with arrays which one you pick?
Give some examples where proc report’s defaults are different than proc print’s defaults?
how does sas handle missing values in assignment statements? : Sas programming
what is change analysis in sas di ? : Sas-di
Which date function advances a date, time or datetime value by a given interval?
What is your favorite all time computer book? Why?
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
How to limit decimal places for the variable using proc means?
what are _numeric_ and _character_ and what do they do? : Sas programming
