Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


how to write code for left outer join in SAs using datastep?

Answers were Sorted based on User's Feedback



how to write code for left outer join in SAs using datastep?..

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

how to write code for left outer join in SAs using datastep?..

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

how to write code for left outer join in SAs using datastep?..

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

how to write code for left outer join in SAs using datastep?..

Answer / jbhjhj

dnt use set it wnt work.
use merge with in statements as above.

Is This Answer Correct ?    8 Yes 6 No

how to write code for left outer join in SAs using datastep?..

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

how to write code for left outer join in SAs using datastep?..

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

how to write code for left outer join in SAs using datastep?..

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

how to write code for left outer join in SAs using datastep?..

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

Post New Answer

More SAS Interview Questions

What are the five ways to do a table lookup in sas? : sas-grid-administration

0 Answers  


How do you connect the desktop application to metadata server? : sas-grid-administration

0 Answers  


hi here is a problem can anybody solve this? i want to report the data through third party file. by using data _null_ or proc report or macro automation process. but i want to insert the 'titles and footnotes' in between the data and also starting of 2nd and ending of 2nd and starting of 3rd and ending of the 3rd page. tell me how and write the code?

0 Answers   Cognizant,


What do you feel about hardcoding?

3 Answers   Pfizer,


how can u convert this 25-jul-2010 from numeric to charcter?

3 Answers  


How do you add a number to a macro variable? : sas-macro

0 Answers  


How many ways to overcome a missing values???

0 Answers   HSBC,


what is the SAS/ACCESS and SAS/CONNECT?

9 Answers   Accenture, iFlex, TCS,


What is _n_?

22 Answers  


What makes sas stand out to be the best over other data analytics tools?

0 Answers  


When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?

7 Answers  


what is picture format? give any one example?

3 Answers   Parexel,


Categories