What is the difference between SAS Data step and SAS PROC SQL, and which is better?

1 Answers   TCS,

---

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 metadata? : Sas-bi

0 Answers  

---

When you will use nowd option in report???

6 Answers   Accenture,

---

how do i get last 10obs from a dataset when we don't know about the number of obsevations in that dataset?

7 Answers   TCS,

---

---

SAS using companies in chennai

1 Answers  

---

What is the size of PDV?

2 Answers   L&T,

---

what is Global Symbol table and Local symbol table?

4 Answers   CitiGroup,

---

i have a dataset with 25 obs; 10th obs has like ramu,anji,ramu,azad,ramu like this. i want to know how many times the word repeats in that obs?

3 Answers  

---

What other SAS features do you use for error trapping and data validation?

2 Answers  

---

Where do the database management systems store data and how do u import them.

2 Answers   L&T,

---

what are the types of interactive display types? : Sas-bi

0 Answers  

---