how can you improve the performance of a query, If it is
excuting very slowly?
- 2 Answers
- 6620 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Mention the validation tools used in SAS?
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
What is the function of Stop statement in a SAS Program?
I need level 2 to 5 sas using companies in india
how could you generate test data with no input data? : Sas programming
Which date function advances a date, time or datetime value by a given interval?
what are _numeric_ and _character_ and what do they do? : Sas programming
What do the put and input function do?
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
This entry was posted in General. Bookmark the permalink. Post a comment or leave
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
What is the length assigned to the target variable by the scan function?
What is the difference between where and if statement?
What is the difference between proportion and average?
What can be the size of largest dataset in SAS?
