if u result look like as follows,its correct result only.. just chk d inf

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.

Question Posted / aravind rangaraj

1 Answers
4702 Views
I also Faced
E-Mail Answers

Answer Posted / aravind rangaraj

if u result look like as follows,its correct result only..
just chk d info observation by observation..
each date in data1 is satisfied..u r confused????
if any output u hav expected just write the output..

output:

dt account startdt enddt total
11OCT1964 1230 15JUL1964 08JAN1965 12300
22OCT1964 1120 15JUL1964 08JAN1965 12300
23NOV1964 1130 15JUL1964 08JAN1965 12300
02NOV1964 1240 15JUL1964 08JAN1965 12300
11OCT1964 1230 06APR1964 24OCT1964 16800
22OCT1964 1120 06APR1964 24OCT1964 16800

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming

1280

What are the statements that are executed only?

1160

Enlist the functions performed by sas.

1133

How do you test for missing values?

1646

How would you define the end of a macro?

1099

For what purpose would you use the RETAIN statement?

1531

what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

1145

How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?

1377

what is transformation in sas data integration? : Sas-di

1039

What are the different versions of sas that you have used until now? : sas-grid-administration

1345

In SAS explain which statement does not perform automatic conversions in comparisons?

1318

what is the difference between floor and ceil functions in sas? : Sas-administrator

1265

Tell e how how dealt with..

2259

What do you understand by the term Normal Distribution?

999

Mention few capabilities of sas framework.

1197