Mention sas system options to debug sas macros.

0 Answers  

---

Have you ever linked SAS code, If so, describe the link and any required statements used to either process the code or the step itself?

4 Answers  

---

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 are the rows present in protocol Violation table?

2 Answers   Accenture, Quintiles,

---

how to shift the rows to cols? eg: i have like field1 field2 field3 10 20 20 this should be displayed as field1 10 field2 20 field3 30 (without the obs col) how do this?can i use transpose or tell me suitable way to do this?

3 Answers   CMC,

---

what are system option ? give few examples ? what are dataset options and dataset statements ? if there is a keep option and keep statement ? which one is executed first ? Difference between a WHERE statement and IF statement ? what is the advantage of using WHERE statement option on the dataset ?

1 Answers   Satyam,

---

what is Difference between PROC SQL JOINS and MERGE?

3 Answers   Accenture, Wipro,

---

How can you create a macro variable with in data step? : sas-macro

0 Answers  

---

i want to upload titles and footnotes to excel file?how it is possible?

1 Answers  

---

PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?

7 Answers   HP,

---

what is sas business intelligence? : Sas-bi

0 Answers  

---

Describe the function and untility of the most difficult SAS macro that you have written.

0 Answers  

---