· What are some good SAS programming practices for
processing very large data sets?
- 6 Answers
- 19422 Views
- Quintiles, I also Faced
- E-Mail Answers
Answer Posted / pricil kurian
1) Compressing dataset
2) Using where instead of if as subsetting conditions
3) Deleting the temporary datasets at the end of the program
4) If we use "if..else ..if conditions"..use most occuring
situations first
5)Use keep and drop appropriately to avoid the unneceesary
variable
6).Creattion of index variable
7)Use of array statement
8)Create one byte required numeric variable which we don't
use for calcualting process as charcater..Using this this
variable need 1 byte where numeric variable's minimum
length is 3.
9)Minimize the CPU time that SAS uses by executing the
minimum number of statements in the most efficient
order.
10)Use SQL for code simplification. A single SQL statement
is generally easier to code and understand than a
long series of SORT and DATA steps.
11)Use of data _null_; when we don't need to output into a
new dataset.
12)Use macros for redundant code.
13)When data sets are large and unsorted, the SQL inner
join may beter than SORT and MERGE.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Difference between nodup and nodupkey options?
what type of graphs we will create(for 2+years candidates)?
what is sas database server? : Sas-di
what are sas bi dashboard components? : Sas-bi
how can you create zero observation dataset? : Sas programming
What are symget and symput? : sas-macro
Differentiate between ceil and floor functions.
Which statement does not perform automatic conversions in comparisons?
What do the put and input function do?
AE datasets names? how many types?
To what type of programms have you used scratch macros?
how many types of prompts are there? : Sas-bi
what is the purpose of _error_? : Sas programming
how sas deals with business intelligence? : Sas-bi
What is the use of stop statement?
