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.

1030

What is the difference between AT SELECTION-SCREEN and AT SELECTION-SCREEN OUTPUT?

438

what comments have u given in peer review? tell me at least 3 comments what u have given? july27 brahma412@yahoo.co.in

791

how to synchronize product with r3 system through middleware?

989

why need to be maintain power factor for industrial customer?

2751

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

762

what is allowable limit Of stray light for a spectrophotometer laboratory instruments ?

254

what is reverse power relay brief explanation and in b/w where it is connected

803

Purchase and sales sahres accounting entry which have stt brokerage and other taxes

2648

rrbchennaimodel question paper for current papers

1702

What is purpose user group in SU01?

1757

Why would you be successful in legal writing?

1362

low of heat transfer

2137

What are Smart Tags and Refactor in Visual Studio?

513

what are the differences between CONS, LIST, and APPEND

2707