how to write code for left outer join in SAs using datastep?
Answer Posted / uma
first sort these datasets by common variable DEPT_ID,Then
use the following:
data left_join;
merge emp (in=a) dept (in=b);
by dept_id;
if a then output;
run;
| Is This Answer Correct ? | 22 Yes | 2 No |
Post New Answer View All Answers
Mention what are the data types does SAS contain?
Which date function advances a date, time or datetime value by a given interval?
Mention the category in which sas informats are placed?
Hi, If anyone has base SAS certification dumps, please share.
What are the different versions of sas that you have used until now? : sas-grid-administration
explain about various caches available in data integrator? : Sas-di
how sas deals with business intelligence? : Sas-bi
How long can a macro variable be? A token? : sas-macro
describe about physical data integration? : Sas-di
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
For what purpose would you use the RETAIN statement?
for report generation which one you used proc report or data_null_?
List down the reasons for choosing sas over other data analytics tools.
what are some differences between proc summary and proc means? : Sas programming
Explain the purpose of retain statement.