compare the variable name and find the errors if any

[Smitha9]

Hi,

I have a variable name format

Chicago Michigan Boston Ohio

New dataset has the following variable name:

Chicag Michigan Bostor Ohid

I need to compare this dataset with the above formatted variable name and report the errors.

Can I code this one?

thank you in advance

[Kurt_Bremser]

Yes, you can.

Use DICTIONARY.COLUMNS (SQL) or SASHELP.VCOLUMN (data step) to compare the variables in both datasets.

e.g.

data check;
merge
  sashelp.vcolumn (in=d1 where=(libname="LIB1" and memname="DS1"))
  sashelp.vcolumn (in=d2 where=(libname="LIB2" and memname="DS2"))
;
by name;
if d1 and d2 then check = "both";
else if d1 then check = "d1";
else check = "d2";
keep name check;
run;

[Reeza]

Have you looked into PROC COMPARE?