how can you improve the performance of a query, If it is
excuting very slowly?
Answers were Sorted based on User's Feedback
Answer / dvsr
If you are execution query on large SAS data sets before
executing the query COMPRESS the data sets by using
sas “compress” option and create the indexes on the most
frequently using variables in the data set
Feel free To add more ….:)
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / himanshu
by creating the Cubes, We can improve the performance of
the query.
| Is This Answer Correct ? | 0 Yes | 1 No |
If money were no object, what would you like to do?
Which command is used to perform sorting in sas program?
How would you include common or reuse to be processed along with your statements?
What is shift table? have you ever created shift that?
2 Answers Accenture, Clinical Research, Quintiles,
how do the in= variables improve the capability of a merge? : Sas programming
what is intially documentation in sas?
Difference Between Scan and Substr
Does SAS ?Translate? (compile) or does it ?Interpret?? Explain.
diff between nodup rec and ondup key???
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
Best trainer in hyderabad for sas banking.if any one have details pls provide contact details.
Does SAS ‘Translate’ (compile) or does it ‘Interpret’? Explain.