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.

0 Answers  

---

What is a post baseline?

1 Answers  

---

What is maximum storage capability of SAS?

0 Answers  

---

how will you location sas platform applications available from web browser? : Sas-bi

0 Answers  

---

/*i have the following dataset.*/ data score; input marks ; datalines; 10 20 30 40 50 60 70 80 90 100 ; run; Now i should get the result as sum of 1 to 5 i.e(10+20+30+40+50)=150 and 2 to 6 i.e(20+30+40+50+60)=200 and 3 to 7 i.e(30+40+50+60+70)=250 and so on. how to get it. thanks in advance

2 Answers   Eval Source,

---

How to create an external dataset with sas code?

0 Answers  

---

how to import XTP files into SAS datasets?

1 Answers   Barclays, Institute For Plasma Research,

---

what is validvarname and varnum? why we are using this options; explain with a syntax for this options?

1 Answers   Max India,

---

How would you remove a format that has been permanently associated with a variables?

3 Answers  

---

what is the primary variable in your study?

3 Answers   Accenture,

---

Mention what are the data types does SAS contain?

0 Answers  

---

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

0 Answers   Pfizer,

---