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 |
We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B
who is the best SAS clinical Trainer in Hyderabad?
what is enterprise guide? What is the use of it? : Sas programming
In the flow of DATA step processing, what is the first action in a typical DATA Step?
What is the difference between %put and symbolgen? : sas-macro
Hi, I have one dataset like id date ex: id date 1 13 1 13Oct2011 2 14 2 14Oct2011 3 15 3 15Oct2011 --->this is the current date here i want date format like 13Oct2011,14Oct2011 how we can modify the numeric to date format plz answer.
how we can call macros with in data step?
sas implimented companies in hyderabad
How to import the Zip files into SAS? If it is possible in SAS? If it is posible write the code...
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
What is the difference between match merge and one to one merge?
what are the new features included in the new version of SAS i.e., SAS9.1.3?
5 Answers College School Exams Tests, Wockhardt,