how can u join the two tables without using proc sql Joins
and nested queries ?

Answer Posted / sai

we can join two tables by using merge statement and also by
using two SET statements .


data one;
set two;
set three;
run;

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

787


Hi, If anyone has base SAS certification dumps, please share.

1623


What is the difference between SAS functions and procedures?

901


what are the types of interactive display types? : Sas-bi

855


If you use a symput in a data step, when and where can you use the macro variable? : sas-macro

834


Have you used macros? For what purpose you have used? : sas-macro

816


What is the difference between class statement and by statement in proc means?

905


how do the in= variables improve the capability of a merge? : Sas programming

1183


how do you test for missing values? : Sas programming

794


if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

1382


what is intially documentation in sas?

4642


what has been your most common programming mistake? : Sas programming

804


how do you pull data from equifax?tell me the process?

1581


What are the difference between sas functions and procedures?

857


What are the new features included in the new version of SAS Programming Language?

964