Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

which date function advances a date, time or datetime value by a given interval? : Sas programming

1097


For what purpose would you use the RETAIN statement?

1585


How we can create SAS USER DEFINED CODE?

2150


what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

1183


How will you generate test data with no input data?

1232


What are the uses of sas?

1360


Explain why double trailing @@ is used in input statement?

1116


explain the key concept of sas? : Sas-administrator

1049


What are the automatic variables for macro? : sas-macro

1327


how many display types available in sas bi dashboard? : Sas-bi

1143


What’s the difference between var b1 – b3 and var b1 — b3?

1440


What is the difference between where and if statement?

1151


What does PROC print, and PROC contents do?

1277


how does sas handle missing values in sort order? : Sas programming

981


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

3554