Answer Posted / anik chatterjee

The last answer is right but if all the values are missing
then sum function will give a note in log. Best way to add
0 with all value. Hence if all value is missing then total
would be 0 and no note will be there.

proc sql;
create table SUM as
select sum(a) as sum_a,
sum(b,0) as sum_b,
sum(c,0) as sum_c,
sum(d,0) as sum_d,
sum(e,0) as sum_e,
sum(f,0) as sum_f
from input_dataset_name;
quit;

hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2106

---

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.

2244

---

How many ways to overcome a missing values???

2863

---

explain about various caches available in data integrator? : Sas-di

1111

---

Difference between SAS STATA & SPSS?

1174

---

What do you know about sas and what we do? : sas-grid-administration

1231

---

what are the categories that sas informats are used to the place the data? : Sas-administrator

1095

---

what is ae onset date n what is RDS

2655

---

What is SAS?

1095

---

What are symget and symput? : sas-macro

1365

---

Differentiate between ceil and floor functions.

1196

---

how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2803

---

Do you know the features of sas?

1086

---

Compare sas with other data analytics tools.

1092

---

What is run-group processing?

1239

---