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 |
Difference b/n proc means and proc summary procedures?
what is the diff b/w verification validation in sas
What is shift table? have you ever created shift that?
2 Answers Accenture, Clinical Research, Quintiles,
What are the prime responsibilities of data integration administrator? : Sas-di
We have a string like this "kannafromsalembut" ,from this i want to get only "fromsal" (but one condition with out using substring function)here we can not use scan because in the given string there is no delimeter? so give ans without out using substring ?
What is the purpose of trailing @ and @@? How do you use them?
What are the different operating system platforms in which we can use sas? : sas-grid-administration
Enlist the functions performed by sas.
how does sas handle missing values in assignment statements? : Sas programming
how can you import .csv file in to sas? : Sas programming
What is the difference between informat and format statement?
how to generate means for every subject;