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
name the scheduler for scheduling job and explain the scheduler? : Sas-di
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
what is business intelligence? : Sas-bi
How to create a permanent sas data set?
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
What is the function of Stop statement in a SAS Program?
Explain the main difference between the sas procedures and functions? : Sas-administrator
Of all your work, where have you been the most successful?
Explain how merging helps to combine data sets.
What commands are used in the case of including or excluding any specific variables in the data set?
What sas features do you use to check errors and data validation?
What is by-group processing?
what is function of retain statment
What is your favorite all time computer book? Why?