topic Re: Proc compare customization for comparison based only on specific attributes of the variable not in SAS Procedures

Proc compare customization for comparison based only on specific attributes of the variable not all

sAura — Fri, 04 Nov 2016 06:03:19 GMT

I have two datasets (ABC1/ABC2), where i need to validate that they are exactly similar (values wise and structure wise) and need to generate a report,

proc compare base=ABC1 compare=ABC2

briefsummary listall;
run;

Issue here is that the dataset ABC2 doesnt contains the variable attribute values like (format, Informat and Label).

Hence the report that is being generated is including all the variables as mismatch because of the misiing attribute values of the variables in ABC2.

I need the output as
Comparison of two dataset based on their variable name, type and length only, the comparison should not include mismatches for their formats, informats or label.

How can I customise the output for this comparison?

Re: Proc compare customization for comparison based only on specific attributes of the variable not

Reeza — Fri, 04 Nov 2016 06:29:36 GMT

Try limiting output with ODS select?

ODS select comparesummary;

Re: Proc compare customization for comparison based only on specific attributes of the variable not

sAura — Fri, 04 Nov 2016 08:38:07 GMT

I need to omit only the data under the header "Listing of Common Variables with Differing Attributes".

Unable to get the desired result from

---ODS select comparesummary;

Re: Proc compare customization for comparison based only on specific attributes of the variable not

BrunoMueller — Fri, 04 Nov 2016 10:00:40 GMT

You can add to FORMAT statements, resetting all the format information like so:

proc compare
  base=ABC2
  compare=ABC1
  novalues
  LISTVAR
;
  format _numeric_;
  format _character_;
run;

Bruno