DATA Step, Macro, Functions and more

How to compare two sas datsets considering only observations.

Reply
Contributor
Posts: 72

How to compare two sas datsets considering only observations.

I have a problem where in I need to compare two sas datasets. But in the two datasets the variable are having different name though its the same data.
I do not want to change the variable name before comparing.
Is there a possiblity of comparing these two datasets supressing variable comparision and let it compare only observation.
for e.g
data a;
var1="aaa";
var2="ggg";
run;

data b;
var_1="aaa";
var_2="ggg";
run;

Please let me know how I can compare these two datasets. In both the datasets the variable var1= var_1 and var2=var_2. I want to show these two variables in the report so that user can refer to them properly.
Super Contributor
Super Contributor
Posts: 3,174

Re: How to compare two sas datsets considering only observations.

Posted in reply to anandbillava
Suggest looking at the COMPARE procedure and the WITH statement.

Scott Barry
SBBWorks,Inc.

Suggested Google advanced search argument, this topic / post:

proc compare different variable names site:sas.com
Ask a Question
Discussion stats
  • 1 reply
  • 160 views
  • 0 likes
  • 2 in conversation