topic PROC COMPARE CHANGE _TYPE_ VARIABLE? in SAS Programming

PROC COMPARE CHANGE _TYPE_ VARIABLE?

JC411911 — Tue, 07 May 2024 16:53:04 GMT

Hello,

I have the below code which is part of larger code that will stop running the rest of the program if there is a difference in the proc compare. It is working okay but I am curious if there is a way to rename the _type_ variable that is created for the comparison. Right now it list BASE and COMPARE which is great but for a user that isn't aware I would like to rename to the actual file names. Is this possible?

%let diff_count = 0;

/* Compare the TO_TAX and FROM_TAX BUWfiles */
PROC COMPARE BASE=WORK.TO_TAX_MODIFIED brief transpose COMPARE=WORK.FROM_TAX_MODIFIED OUT=COMPARISON OUTBASE OUTCOMP OUTDIF LISTOBS OUTNOEQUAL BRIEFSUMMARY;
    VAR member_number account_number payer_id ;
    title 'COMPARING FILE SENT AND RECEIVED FROM';
RUN;

DATA _NULL_;
    SET COMPARISON END=eof;
    IF eof THEN CALL SYMPUT('diff_count', _N_);
RUN;

Re: PROC COMPARE CHANGE _TYPE_ VARIABLE?

Tom — Tue, 07 May 2024 17:07:59 GMT

Are asking how to make a COPY of the OUTPUT dataset from PROC COMPARE where you replace the values "BASE" and "COMPARE" in the variable _TYPE_ with the names of the datasets that were compared?

That should be simple, as long as you actually have the names. In your example code the names are only in the CODE, they are not anywhere that a program could find them. If you have the names in a macro variable for example.

%let base=TO_TAX_MODIFIED ;
%let compare=FROM_TAX_MODIFIED ;
proc compare base=&base compare=&compare out=COMPARISON .....
...

data COMPARISON ;
  length _type_ $41 ;
  set COMPARISON ;
  if _type_="BASE" then _type_="&base";
  if _type_="COMPARE" then _type_="&compare";
run;

Re: PROC COMPARE CHANGE _TYPE_ VARIABLE?

ballardw — Tue, 07 May 2024 17:18:50 GMT

First, which data set is this?

Are the "users" looking at the table view or a report generated from that data set?

Typically the response when related to "display a value" question is "use a format". Then either assign the format to the variable in a data set, which may have issues if you recreate the same format name, or use it to generate a report.

Something like:

data work.class;
   set sashelp.class;
   if name = 'Alice' then sex='M';
run;

PROC COMPARE BASE=sashelp.class brief transpose COMPARE=work.class OUT=work.COMPARISON OUTBASE OUTCOMP OUTDIF LISTOBS OUTNOEQUAL BRIEFSUMMARY;
RUN;

proc format library=work;
value $compbase
'BASE'='Sashelp.class'
'COMPARE'='Work.Class'
;
run;

/* modify the report data set to use the format*/
proc datasets library=work nodetails;
   modify Comparison;
   format _type_ $compbase.;
   run;
quit;

First make a data set with a difference to see the result.

Create the output and format, then assign that format to the dataset.

Or use a data step to add a variable with the name of the data set based on the value of _type_. The length of the _type_ variable is almost certainly going to be too short to accept many Library.datasetname values.

data work.final;
   set work.comparison;
   length setname $ 41;
   setname = put(_type_,$compbase.);
run;

This will have values like DIF in the Setname values by default as there is nothing in the format definition to change that. Or use If/then/else instead of a format.

The last may be preferred with shared data sets.

Re: PROC COMPARE CHANGE _TYPE_ VARIABLE?

JC411911 — Tue, 07 May 2024 18:33:58 GMT

Thank you simple enough. That gives me what I was needing. I guess my though was doing it in the proc compare step but seems like the base and compare observations are standard thus the need to create a separate data step to rename. Thank you

Re: PROC COMPARE CHANGE _TYPE_ VARIABLE?

JC411911 — Tue, 07 May 2024 18:35:04 GMT

Thank you, this process works!