· 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
What does PROC print, and PROC contents do?
what is data integration? : Sas-di
what is the function of catx syntax? : Sas-administrator
what is SAS OPTIMIZATION?
What are the default statistics for means procedure?
which date functions advances a date time or date/time value by a given interval? : Sas programming
how does sas handle missing values in formats? : Sas programming
Which statement does not perform automatic conversions in comparisons?
What are the different servers in sas? : sas-grid-administration
what techniques and/or procs do you use for tables? : Sas programming
Explain translate function?
What are the implications?
Tell me about % include and % eval? : sas-macro
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.
What are the advantages of using sas?