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

Answer Posted / sibin

Use
1.WHERE Condition
2.DROP KEEP in Set Statement
3.ARRAY
4.Mutually Exclusive Conditions like DO ,DO UNTIL,DO WHILE

Is This Answer Correct ?    16 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does PROC print, and PROC contents do?

689


what is data integration? : Sas-di

585


what is the function of catx syntax? : Sas-administrator

624


what is SAS OPTIMIZATION?

1791


What are the default statistics for means procedure?

614






which date functions advances a date time or date/time value by a given interval? : Sas programming

507


how does sas handle missing values in formats? : Sas programming

553


Which statement does not perform automatic conversions in comparisons?

1177


What are the different servers in sas? : sas-grid-administration

574


what techniques and/or procs do you use for tables? : Sas programming

553


Explain translate function?

599


What are the implications?

1157


Tell me about % include and % eval? : sas-macro

650


I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

1669


What are the advantages of using sas?

583