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.

2183

What is Abstract Class in Ax? How you will define?

162

Can you explain tpa analysis?

1077

Are Typescript and Javascript the same?

977

mention what are the various methods provided by the dataset object to generate xml?

977

What does a red triangle at the top right of a cell indicates?

615

What are Delivery classes? What data will you want to transport during client copy?

1407

What language is apache kafka written in?

521

What is OOP Language?

1049

What are the names of the species of frogs that have the ability to change what sex (male/female) they are?

2197

Who whoami linux?

982

What are fragments primarily used for?

446

What is the role of the datareader class in ado.net connections?

889

Is wix a cms?

264

Explain what is the difference between power center & power mart?

971