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 |
explain what is factor analysis? : Sas-administrator
what is treatment emergent events and treatment emregent adverse event
Hi, I need to create a SAS Map of USA using SAS Graphs(Proc Gmap).The data i have dosent contain any co-ordinates of USA cities or counties or states, and the zip codes are diffrent in the data i have from the zip code in the Maps.US dataset in the Maps Library for SAS MAPS. the data i have is a sales report. i have to generate the maps according to the states,cities aligned in the sales data, HELP Appriciated
what are validation tools that are used in sas? : Sas-administrator
Enlist the syntax rules followed in sas statements.
There are 200 observations in a dataset, i want to pull out the observation no's 100, 150,180,190 by using Proc SQL? How you can get it?
what are the different ways of merging two datasets.name atleast 4.
how to perform paired t-test using Base/SAS & SAS/Stat?
Tell e how how dealt with..
What was the last computer book you purchased? Why?
What is the purpose of _error_?
Which are the statements whose placement in the data step is critical?