how do you validate tables abd reports?

2 Answers   Accenture, Quintiles,

---

How would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable?

1 Answers   Quintiles,

---

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.

1 Answers  

---

Which command is used to perform sorting in sas program?

0 Answers  

---

What are the data types in sas?

0 Answers  

---

---

How do you add a number to a macro variable?

3 Answers  

---

what is proc Index? and what is proc document?

0 Answers   Mind Tree,

---

I Here clinical SAS training by Ramesh Azmeera is good. Is it confirm ?

2 Answers  

---

what is program data vector? : Sas-administrator

0 Answers  

---

Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.

3 Answers  

---

What system options would you use to help debug a macro? : sas-macro

0 Answers  

---

How would you remove a format that has been permanently associated with a variables?

3 Answers  

---