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 |
How would you delete observations with duplicate keys?
SAS System ?
hi guys ...i have one query... data abc; input s w k g o t a m; cards; 1 2 3 4 5 6 7 8 2 3 4 5 6 7 8 9 ; run; i want the output to be the sorted order(only variables).observations should not be changed..
How you can read the variables that you need?
what do you mean by data staging area? : Sas-di
what is washout period?
Name the option to produce a frequency line items rather that a table.
How would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable?
what is in stream data in SAS?
explain the key concept of sas? : Sas-administrator
Is it possible to do sorting tranformation in charecter variable??if can tell me one eg..
it will become easy if uuu provide website linkssss and list of consultanciessssss