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 |
what are the types of interactive display types? : Sas-bi
What do the put and input function do?
What is the basic structure of a sas program?
How can you put a "trace" in your program?
What versions of SAS have you used (on which platforms)?
What can be the size of largest dataset in SAS?
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
How do you download a flat file from Mainframe to your local PC using SAS?
what is star schema? : Sas-di
What type of tables you are using in YOUR reporting..???
2 Answers GSK GlaxoSmithKline,
what is program data vector? : Sas-administrator
What are the default statistics that proc means produce?