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
- 1780 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
describe about joins? briefly?
what is the diff b/w verification validation in sas
What is difference between rename and lable in sas?
what are the three main credit bureau names
1 Answers Synchrony Financial,
What is the role of sas grid administrator? : sas-grid-administration
Hi... this is chandu, did MSc Microbiology, trying to get job in SAS tool, PLZ Tell me whether IT industries will give consider my education to gain a job....?
Is it possible to do sorting tranformation in charecter variable??if can tell me one eg..
what is SAS/Access and SAS/Connect?what are the uses?
why is a stop statement needed for the point=option on a set statement? : Sas programming
What is a method to debug and test your SAS program?
What is data _null_?
how to generate means for every subject;
Teradata 
