how can you improve the performance of a query, If it is
excuting very slowly?
- 2 Answers
- 6585 Views
- Zensar, I also Faced
- E-Mail Answers
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 |
i have a dataset with var1,var2,var3; i want to upload the titles for the variables . How can we?
What does a PROC TRANSPOSE do?
In the flow of DATA step processing, what is the first action in a typical DATA Step?
What system options would you use to help debug a macro? : sas-macro
What is data _null_?
What is Transaction...? And what are Comment, Roll back n Save point..?
Differentiate input and infile.
do you need to know if there are any missing values? : Sas programming
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
how will you location sas platform applications available from web browser? : Sas-bi
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
What is the pound sign used for in the data_null_ ?
Teradata 
