how to write code for left outer join in SAs using datastep?
Answer Posted / raghava
proc sql;
select *
from one left join two
on one.X=two.X;
quit;
The above is code for lefjoin.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the implications?
what is hash files in sas and why we are using this one in sas?
What is SAS? What are the functions does it performs?
what is sas data set?
What are the statements that are executed only?
describe about metadata object? : Sas-di
What do the mod and int function do? : Sas programming
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
what is business intelligence? : Sas-bi
what are the types of interactive display types? : Sas-bi
What do you know about sas data set?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
which features do you use to check the data validations and errors? : Sas-administrator
What is the purpose of trailing @ and @@? How do you use them?
what is SAS OPTIMIZATION?