how to write code for left outer join in SAs using datastep?
Answer Posted / aniruddha
Data left_outer;
merge emp(in=a) dept(in=b);
by deptno;
if a=1 and b=0;
run;
| Is This Answer Correct ? | 22 Yes | 8 No |
Post New Answer View All Answers
What is the difference between order and group variable in proc report?
What is maximum number of rows and cols can be handled in SAS?
How does proc sql work?
Enlist the syntax rules followed in sas statements.
What is a put statement?
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
What are the data types that sas contain?
What is the order of application for output data set options, input data set options and SAS statements?
Are you involved in writing the inferential analysis plan? Tables specifications?
What is the use of %include statement?
Mention what is the difference between nodupkey and nodup options?
How can you create a macro variable with in data step? : sas-macro
How do you test for missing values?
Which command is used to perform sorting in sas program?