Interested to Buy Any Domain ? << Click Here >> for more details...
how to write code for left outer join in SAs using datastep?
- 8 Answers
- 21286 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 is the difference between nodupkey and nodup options?
Name types of category in which SAS Informats are placed?
1.How many ways are there to create variables? 2.What is CLM,how can we use it? 3.what are the advontages of data step? 4.what is the extension of editor window in SAS 9.1.3? 5.How do you copy a particular data set from one library to another? 6.what is the use of double option? 7.Advontages of Proc Report? 8.what is the basic use of where statement? 9.How do you terminate the statments in SAS Programming? 10.What is the difference between symput and symget? 11.How would a identify the local and global variable? can any one answer for the 4'th question
How long can a macro variable be? A token? : sas-macro
what other SAS features do you use for error trapping and data validation?
what is hierarchy flattening? : Sas-di
Hi I have list of products in a dataset, which are classified by other name for eg:- there is a product A> Malambo Shiraz Malbec 750ML(0388) which is a Red wine.Now i need to generate a report where it shows if this product appears then it should b displayed as red wine,similarly for other products and other classification. I dont wan use proc format.
What do the mod and int function do? : Sas programming
how can you put a "trace" in your program? : Sas programming
what is enterprise guide? What is the use of it? : Sas programming
Explain how merging helps to combine data sets.
Briefly explain input and put function?
Teradata 
