topic Re: compare the variable name and find the errors if any in New SAS User

compare the variable name and find the errors if any

Smitha9 — Tue, 03 Nov 2020 19:30:07 GMT

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

Re: compare the variable name and find the errors if any

Kurt_Bremser — Tue, 03 Nov 2020 19:43:01 GMT

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;

Re: compare the variable name and find the errors if any

Reeza — Tue, 03 Nov 2020 20:07:33 GMT

Have you looked into PROC COMPARE?