how can you improve the performance of a query, If it is
excuting very slowly?
- 2 Answers
- 6611 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 |
What do the mod and int function do? : Sas programming
What are types of transport files?
2 Answers PRA Health Sciences, Quintiles,
Have you ever linked SAS code? If so, describe the link and any required statements used to either process the code or the step itself.
What are the applications primarily used by business analyst? : Sas-bi
I am having a stored process.it needs to route my report to both hthml and Xls.By default SP routes to html.I used the PRINTTO to route the html to Xls.BUt it createsthe file not but no content was written to file(0KB)?how can i do it?
How do you read in the variables that you need?
Which is the best training institute for SAS in hyderabad.
112 Answers Stansys Software Solutions,
why is a stop statement needed for the point=option on a set statement? : Sas programming
How would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable?
if x=round(26.3,10)-1 then x= how much and how explain?
what is the difference between informat$8. $char8.
What is by-group processing?
Teradata 
