Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5538 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
What is the use of divide function?
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
Mention some common errors that are usually committed in sas programming.
Name some categories in sas 9? : sas-grid-administration
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
what are the benefits of data integration? : Sas-di
what is change analysis in sas di ? : Sas-di
what is the basic structure sas administrator? : Sas-administrator
What does proc print, and proc contents are used for?
How would you identify a macro variable?
What do the put and input function do?
What are the table names in oracle database...?
How to limit decimal places for the variable using proc means?
What is the use of function Proc summary?
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
