how can you improve the performance of a query, If it is
excuting very slowly?
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
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
name several ways to achieve efficiency in your program? : Sas programming
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
What is Linear Regression?
Mention the validation tools used in SAS?
How you can read the variables that you need?
What makes sas stand out to be the best over other data analytics tools?
What are all the problems you faced while validating tables and reports?
it will become easy if uuu provide website linkssss and list of consultanciessssss
Differences between where and if statement?
what are informats in sas? : Sas-administrator
why is sas data integration studio important? : Sas-di
How long can a macro variable be? A token? : sas-macro
How sas treats the dsd delimiters?
What is the difference between reading data from an external file and reading data from an existing data set?