Interested to Buy Any Domain ? << Click Here >> for more details...
how to write code for left outer join in SAs using datastep?
- 8 Answers
- 21553 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 are the best practices to process the large data sets in sas programming? : Sas-administrator
What SAS statements would you code to read an external raw data file to a DATA step?
How does the internal authentication work in sas? : sas-grid-administration
What is the difference between input and infile statement?
What is the size of PDV?
How do you use the do loop if you don’t know how many times you should execute the do loop?
hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?
How to write duplicate records into a separate dataset using sort?
How would you code a merge that will keep only the observations that have matches from both sets?
I need level 2 to 5 sas using companies in india
What are the different types of sas functions?
Mention what is PROC in SAS?
Teradata 
