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
what does the run statement do? : Sas programming
what is star schema? : Sas-di
what are the categories that sas informats are used to the place the data? : Sas-administrator
What is the basic syntax of a sas program?
To what type of programms have you used scratch macros?
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
Mention what is the difference between nodupkey and nodup options?
What are the data types does SAS contain?
Name and describe few sas character functions that are used for data cleaning in brief.
What was the last computer book you purchased? Why?
What are the advantages of using sas?
explain the difference between proc means and proc summary?
AE datasets names? how many types?
what is the difference between nodup and nodupkey options? : Sas programming
What is the role of unrestrictive users? : sas-grid-administration