how to write code for left outer join in SAs using datastep?
- 8 Answers
- 19055 Views
- CitiGroup, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / lakshmi
data left_join;
merge data1(in=a) data2(in=b);
by subjid;
if a;
run;
| Is This Answer Correct ? | 10 Yes | 3 No |
Answer / jbhjhj
dnt use set it wnt work.
use merge with in statements as above.
| Is This Answer Correct ? | 8 Yes | 6 No |
Answer / venkatesh
if you use x=1 and y=0
you must use set statement also
try this
data a b;
merge one two;
by id;
if x=1 and y=1 then output a;
if x=1 and y=0 then output b;
data new;
set a b;
run;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / vk
Data Left_outer;
set data1(in=x) data2(in=y);
if x=0 and y=1;
run;
| Is This Answer Correct ? | 9 Yes | 12 No |
Answer / pnprasad
There is no such Inner & Left Joins. In SAS only one join
i.e Right Join. If you want Left Join you have to use the
data set in the second place. For example: D1 D2 are the
data sets for D2 you want to make, UPDATE D1 D2;
| Is This Answer Correct ? | 1 Yes | 22 No |
What statement do you code to tell SAS that it is to write to an external file?
If you set a label in the data step and call a proc freq on the data, how do you display the data without the labels and just the variables.
what is sas database server? : Sas-di
Write a SAS macro to calculate number of numbers in an email address
Of all your work, where have you been the most successful?
Did you used proc lifetest? when?
2 Answers Accenture, Parexel, Quintiles,
What are the five ways to do a table lookup in sas? : sas-grid-administration
Why do we use QUIT commmand for proc datasets and proc sql ???
Describe a time when you were really stuck on a problem and how you solved it?
Explain the difference between informat and format with an example.
Explain the purpose of substr functions in sas programming.
What do you code to create a macro? : sas-macro
Teradata 
