Answer / santosh

as per my understanding this is the solution
without renaming the variables the only way is to do using
proc sql;
select a.age,b.age from a,b;
quit;

Answer / presha badiyani

use rename option

Data a1;
input A $20 @50 age;

Data b1;
input x b age;

Data c;
set a1 b1(rename age=b1_age);
If age = b1_age;
run;

Answer / poojavaibhav

Deepak please explain the word functionality in detail.

But if i have to answer above question then i think if you have var that have same name in different dataset and you want to use them both then rename one of the variable and apply condition..

thanks.

Answer / alok karan

Data a1;
input y age;

Data b1;
input x age;

Data c;
set a1 b1(drop=age);
run; 

Answer / kush

proc sql;
select Variable_name
from Variable_name.DataSet_name;
run;

Answer / nbohr02

Use a two level name.

Data a1;
input A $20 @50 age;

Data b1;
input x b age;

Data c
If a1.age = b1.age;

what does .. meant in sas macros

3 Answers   D&B,

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

0 Answers  

Do you use PROC REPORT or PROC TABULATE? Which do you prefer? Explain.

3 Answers  

what is the Population you used in your project, is it ITT or PP?

0 Answers   Accenture, Quintiles,

explain about data integrator metadata reports? : Sas-di

0 Answers  

how to read the variables in sas? : Sas-administrator

0 Answers  

hi i date is 05sep2005; i want the oupput like 05sep2005:00:00:00 ; how it wil come?

6 Answers   Accenture,

what is the difference between nodup and nodupkey options? : Sas programming

0 Answers  

what is business intelligence? : Sas-bi

0 Answers  

what is null hypothesis? why do you consider that?

0 Answers   Accenture, Quintiles,

What is the command used to find missing values?

0 Answers  

which features do you use to check the data validations and errors? : Sas-administrator

0 Answers