Interested to Buy Any Domain ? << Click Here >> for more details...
How do you use the do loop if you don’t know how many times you should execute the do loop?
- 0 Answers
- 1304 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is proc sql pass through facility?
explain about data integrator metadata reports? : Sas-di
what are the new features included in the new version of SAS i.e., SAS9.1.3?
5 Answers College School Exams Tests, Wockhardt,
When merging 2 datasets with a common variable (not merge key), how to keep both?
how can you import .csv file in to sas? : Sas programming
What is difference between rename and lable in sas?
what is change analysis in sas di ? : Sas-di
What is the difference between SAS Data step and SAS PROC SQL, and which is better?
what is SAS/Graph?
why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
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.
Teradata 
