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  

---

I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com

0 Answers  

---

what is pdv? how it is related to input buffer in sas?

5 Answers   HSBC, Satyam,

---

What is difference between (a-z) and (a--z)

8 Answers   Accenture,

---

What is a method to debug and test your SAS program?

0 Answers  

---

what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

0 Answers  

---

Does anybody has lastest SAS certification dumps,if anybody has please mail me at akshara_SAS@ymail.com Thanks Akshara

55 Answers  

---

If i doest required Cumilative frequency in my table, generated by using PROC FREQ what i had to do?

8 Answers   HCL,

---

Difference between nodup and nodupkey options?

0 Answers  

---

what are the sites did u refer for enquiries and doubts for SAS

2 Answers   UBS,

---

Are the preferred term counts are always equal to Body system counts? If so, Why are they equal if not why they are not equal?

1 Answers   Icon,

---

what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming

0 Answers  

---