1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.

1 Answers  

---

How to import the Zip files into SAS? If it is possible in SAS? If it is posible write the code...

7 Answers  

---

What is the purpose of the trailing and How would you use them?

8 Answers  

---

How to Rename Library?

3 Answers  

---

sas implimented companies in hyderabad

11 Answers   CTS, HSBC,

---

---

what is TAB delimiter? explain about it? what will you do to get TAB delimiter?

3 Answers   Cap Gemini,

---

Mention what are the data types does SAS contain?

0 Answers  

---

What is the difference between match merge and one to one merge?

0 Answers  

---

what is the use of proc sql?

5 Answers   CitiGroup,

---

explain the proc in sas? : Sas-administrator

0 Answers  

---

What data sets do you need to produce the report?

2 Answers   Novartis,

---

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  

---