is it possible to generate sas datasets using proc print ???

1 Answers   GSK GlaxoSmithKline,

---

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 broad cast agent? : Sas-bi

0 Answers  

---

What is the difference between nodupkey and nodup options?

0 Answers  

---

How did you use the round function?give an example(don't say it will round to the nearest intger) eg1:round(84.55,.1) =84.6 eg2:round(92.64,.1)=92.6,How it is happening like this tell me the logic,that is how the round function works when we have deimal values?

2 Answers   BoA,

---

how can get the first and last observations in a dataset using Proc SQl?

4 Answers   Satyam,

---

How could i automate the code in the scenario:Every month one new data set will be created for that perticular month transaction list.Now i would like to update the data in the source table by appending every month data automatically. jan---set jan; feb---set jan feb; mar---set jan mar;

2 Answers   HSBC,

---

What is the difference between Proc tabulate and Proc print

4 Answers   CitiGroup,

---

how to intersect the tables by using PROC MIXED?

1 Answers   CitiGroup,

---

what is hash files in sas and why we are using this one in sas?

0 Answers   L&T, SAS,

---

What is connection profile? : sas-grid-administration

0 Answers  

---

Explain why double trailing @@ is used in input statement?

0 Answers  

---