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 use of the %include statement?
What are the features of SAS?
Give some examples where proc report’s defaults are different than proc print’s defaults?
What is the command used to find missing values?
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
Explain by-group processing?
What would you change about your job?
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? What are the implications?
Give e an example of..
How necessary is it to be creative in your work?
what is null hypothesis? why do you consider that?
what is the function of catx syntax? : Sas-administrator
If you use a symput in a data step, when and where can you use the macro variable? : sas-macro
I need level 2 to 5 sas using companies in india