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
Which are the statements whose placement in the data step is critical?
What are the data types does SAS contain?
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
What is the order of application for output data set options, input data set options and SAS statements?
What is the role of sas grid administrator? : sas-grid-administration
What is the basic syntax of a sas program?
How do you convert basic cube to transaction cube and transaction cube to basic cube?
: and & modifiers.
What do you know about sas and what we do? : sas-grid-administration
Which command is used to perform sorting in sas program?
What is the maximum and minimum length of macro variable
What are the ways to do a “table lookup” in sas?
how to change the execute of macro
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming