Answer / reshma

proc sort data=dataA;
by commonvar;
run;

proc sort data=dataB;
by commonvar;
run;

data new;
merge dataA (in=a) dataB (in=b);
if a ;
by commonvar;
run;

Name statements that are execution only.

14 Answers   Accenture,

---

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 special input delimiters used in SAS?

0 Answers  

---

Does anybody have SAS Training manual or documentation or can you refer me any book to have better understanding on SAS. I am fresher to SAS tool. (Ready to pay)

4 Answers  

---

WHAT IS DEBUGGING? HOW TO TEST THE DEBUGGING IN SAS?

3 Answers   Accenture,

---

how can you sort the dataset having millions of OBS(instead of sort procedure?

4 Answers   EXL,

---

What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

0 Answers   Quintiles,

---

name some data transformation used in sas di? : Sas-di

0 Answers  

---

Explain how merging helps to combine data sets.

0 Answers  

---

what is null hypothesis? why do you consider that?

0 Answers   Accenture, Quintiles,

---

Can we use where and having clauses in a single SAS program. ex: proc sql;     select a,b,c from test      where state in 'KA'      and having <some condition>. Is the above program run correctly, if not why ?     

4 Answers   UHG,

---

If you set a label in the data step and call a proc freq on the data, how do you display the data without the labels and just the variables.

1 Answers  

---