Interview Questions   Tutorials   Discussions   Programs   Videos   

SAS - What are some good SAS programming practices for processing very large data sets?




417
views
asked mar September 20, 2014 06:30 AM  

What are some good SAS programming practices for processing very large data sets?


           

1 Answers



 
answered By vishnoiprem   0  
  1. Compressing dataset Using where
    instead of if as subsetting
    conditions3) Deleting the temporary datasets at the end of the program If we use "if..else ..if
    conditions"..use most occurring
    situations first Use keep and drop
    appropriately to avoid the
    unnecessary variable Creation of
    index variable Use of array statement Create one byte required numeric variable which we don't use for calculating process as character..Using this this variable need 1 byte where numeric variable's minimum length is 3. Minimize the CPU time that SAS uses by executing the minimum number of statements in the most efficient order. 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. Use of data null; when we don't need to output into a Use macros for redundant code. When data sets are large and unsorted, the SQL inner join may better than SORT and MERGE. Compressing dataset Using where instead of if as sub-setting conditions Deleting the temporary datasets at the end of the program If we use "if..else ..if conditions"..use most occurring situations first Use keep and drop appropriately to avoid the unnecessary variable Creation of index variable Use of array statement
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert