Answer / prashanth

what ever data we mentioned in cards is called as instream
data.

What are the 3 components in sas programming?

0 Answers  

---

What is proc sql pass through facility?

4 Answers   L&T,

---

If you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE?

1 Answers   HCL, Quintiles,

---

Differentiate between proc means and proc summary.

0 Answers  

---

Can anyone help to find a statement to get all the predefined formats?

3 Answers   Verinon Technology Solutions,

---

What is the maximum length of the macro variable? : sas-macro

0 Answers  

---

What function CATX syntax does?

0 Answers  

---

Which is the best place to learn SAS clinicals and Oracle clinical in hyderabad?

2 Answers  

---

What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?

1 Answers   Quintiles,

---

What are MIs reports? what is the use of MIS reports and How can u generate the MIS reports in SAS? If any body know explain with the eg.

2 Answers   ABC, ASD Lab, CitiGroup,

---

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.

0 Answers  

---

What can you learn from the SAS log when debugging?

0 Answers   Quintiles,

---