why is a stop statement needed for the point=option on a set statement? : Sas programming
What is the difference between nodup and nodupkey options?
20 Answers iFlex, Makro, Talwar,
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
how does sas handle missing values in functions? : Sas programming
What are Dashboard reports?And significance of these in analysis?
How many tiers in sas architecture?
name several ways to achieve efficiency in your program? : Sas programming
what are the best practices to process the large data sets in sas programming? : Sas-administrator
Explain what is data step?
What is the difference between nodupkey and nodup options?
What is the purpose of _error_?
how to assign a macro value to a variable?
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.