What is meant by Resonance what are the different types of resonance and what are uses of them?
14 50794Post New Infosys Interview Questions
what are the requirements to enable remote components to interact each other?
What are the file extensions for razor views?
why have u choose this ME-engg design department
Define what is the language used for expressing scenario in feature file?
What are the four major components of mvc?
What are the functions of windows operating system?
What is the difference between static testing and dynamic testing?
Explain java coding standards for constants?
How can I insert a tab in a table cell?
What are the different methods through which a user can register for do not call registry? : insurance cold calling
Why do we need to go for JQuery?
How does polymorphism work in perl?
Generic function for selecting a Radio Button in a Dialog
What does mean by a neutral culture?
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.