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 does PROC print, and PROC contents do?
Compare sas with other data analytics tools.
what are validation tools that are used in sas? : Sas-administrator
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
What is the maximum length of the macro variable? : sas-macro
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
how does sas handle missing values in sort order? : Sas programming
Tell e how how dealt with..
Given an unsorted data set, how to read the last observation to a new data set?
What is proc sort?
what is sas data set?
Define run-group processing?
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
What do you know about sas data set?
Name any two sas spawners? : sas-grid-administration