Interested to Buy Any Domain ? << Click Here >> for more details...
· What are some good SAS programming practices for
processing very large data sets?
- 6 Answers
- 20690 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
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
How to limit decimal places for the variable using proc means?
what are sas/access and sas/connect? : Sas programming
describe about physical data integration? : Sas-di
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
Do you need to rearrange the order of the data for the report?
What are the functions used for character handling?
what type of graphs we will create(for 2+years candidates)?
What makes sas stand out to be the best over other data analytics tools?
What are the ways to do a “table lookup” in sas?
How do dates work in sas?
why is a stop statement needed for the point=option on a set statement? : Sas programming
Explain how you can debug and test your SAS program?
What is the differnce between SDTM 3.1.2 to 3.1.1 version
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
