· What are some good SAS programming practices for
processing very large data sets?
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 are the features of SAS?
Describe the function and untility of the most difficult SAS macro that you have written.
what are the categories that sas informats are used to the place the data? : Sas-administrator
How we can call macros with in data step? : sas-macro
describe about physical data integration? : Sas-di
What is the difference between class statement and by statement in proc means?
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
What is the good sas programming practices for processing large data sets?
What areas of SAS are you most interested in?
how to remove duplicates using proc sql?
How can I remove header from output data set?
how does sas handle missing values in formats? : Sas programming
What is connection profile? : sas-grid-administration
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
Describe 5 ways to do a “table lookup” in SAS?