Answer Posted / venkatesh

if you use x=1 and y=0
you must use set statement also
try this
data a b;
merge one two;
by id;
if x=1 and y=1 then output a;
if x=1 and y=0 then output b;
data new;
set a b;
run;

What are the 3 components in sas programming?

1199

---

Tell me more about the parameters in macro? : sas-macro

1054

---

What is the differnce between SDTM 3.1.2 to 3.1.1 version

5077

---

what are some good sas programming practices for processing very large data sets? : Sas programming

938

---

What is a method to debug and test your SAS program?

1381

---

Briefly explain input and put function?

1087

---

Describe a time when you were really stuck on a problem and how you solved it?

2555

---

please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

2106

---

Explain append procedure?

1090

---

What are the difference between the sas data step and sas procs?

1189

---

What are the ways to do a “table lookup” in sas?

1032

---

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

2207

---

For what purpose would you use the RETAIN statement?

1527

---

what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

1020

---

What are the default statistics for means procedure?

1253

---