topic Re: Reg: Compare for matching and non matching varaibles in two datsets. in SAS Procedures

Reg: Compare for matching and non matching varaibles in two datsets.

deleted_user — Wed, 08 Sep 2010 12:01:12 GMT

Hi
i am having two datasets x and y in dataset x i am having variables a,b,c,d
and in dataset y i am having variables a,b,s,d
now i want to find out how many matching variables are there for both the dataset and not matching .If matching it should be outputed to new dataset,if not compared it should be outputed to anohter dataset.IF MATCHED THE DATASETS SHOULD BE APPENDED.

Re: Reg: Compare for matching and non matching varaibles in two datsets.

polingjw — Wed, 08 Sep 2010 13:57:49 GMT

Just to make sure that I understand, you just want to determine whether the variable names match, not the data values right? If this is correct, you should look into using sashelp.vcolumn. Something like this:

data X_variables(keep=name);
set sashelp.vcolumn(where=(libname='WORK' and memname = 'X'));
data Y_variables(keep=name);
set sashelp.vcolumn(where=(libname='WORK' and memname = 'Y'));
proc sort data=X_variables; by name;
proc sort data=Y_variables; by name;

data matching nonmatching;
merge X_variables(in=inX) Y_variables(in=inY);
by name;
if inX and inY then output matching;
else output nonmatching;
run;

Re: Reg: Compare for matching and non matching varaibles in two datsets.

deleted_user — Thu, 09 Sep 2010 05:00:17 GMT

Thanks for your query but in non matched dataset i wnat to find the variables from which dataset they are compning from x dataset or y dataset.i wnat like this sir

data x;
input a b c;
run;

data y;
input a b d e;
run;

matched: a b
nonmatched :
variables datasetset
c x
d y
e y

Re: Reg: Compare for matching and non matching varaibles in two datsets.

deleted_user — Thu, 09 Sep 2010 05:02:18 GMT

Re: Reg: Compare for matching and non matching varaibles in two datsets.

polingjw — Thu, 09 Sep 2010 10:10:20 GMT

That can be done by keeping the memname variable from sashelp.vcolumn:

data X_variables(keep=name memname);
set sashelp.vcolumn(where=(libname='WORK' and memname = 'X'));
data Y_variables(keep=name memname);
set sashelp.vcolumn(where=(libname='WORK' and memname = 'Y'));
proc sort data=X_variables; by name;
proc sort data=Y_variables; by name;

data matching(drop=memname) nonmatching;
merge X_variables(in=inX) Y_variables(in=inY);
by name;
if inX and inY then output matching;
else output nonmatching;
run;

Re: Reg: Compare for matching and non matching varaibles in two datsets.

data_null__ — Thu, 09 Sep 2010 14:41:32 GMT

I would use PROC COMPARE for this. You can figure out how to make the output look like you want.

[pre]
data x; input a b c f:$1. ; cards;
run;
data y; input a b d e f; cards;
run;

proc compare base=x(obs=1) compare=y(obs=1) listvar novalues;
ods exclude CompareSummary;
run;
[/pre]