topic Re: Compare values from one table to another in SAS Programming

Compare values from one table to another

VCucu — Thu, 29 Apr 2021 10:59:24 GMT

Today is: 29.04.2021

I would like to write a code

1) create a variable based on currentdate generation = 202104 (yyyymm - in our example)
2) search the value from 1 and compare the "server" table latest ID Load value (biggest) = 3 (in our example) with the "local" table latest ID Load value (biggest) =2 (in our example)
3) if a newer version (bigger) value on "server" then i will run a specific macro

can somebody help me with this ?

thank you very much,

Re: Compare values from one table to another

Kurt_Bremser — Thu, 29 Apr 2021 11:03:49 GMT

Please supply example data in usable form (data steps with datalines). We cannot run code against pictures.

Re: Compare values from one table to another

VCucu — Thu, 29 Apr 2021 11:09:07 GMT

DATA server; INPUT mandant generation id; CARDS; 196 202103 1 196 202103 2 196 202104 1 196 202104 2 196 202104 3 ; RUN; DATA local; INPUT mandant generation id; CARDS; 196 202104 2 ; RUN;

Re: Compare values from one table to another

Kurt_Bremser — Thu, 29 Apr 2021 11:23:47 GMT

%macro yourmac(mandant,generation,s_id,l_id);
%put &=mandant. &=generation. &=s_id. &=l_id.;
%mend;

%put DATA server;
INPUT mandant generation id;
CARDS;
196 202103 1
196 202103 2
196 202104 1
196 202104 2
196 202104 3
;

DATA local;
INPUT mandant generation id;
CARDS;
196 202104 2
;

data want;
merge
  server (in=s)
  local (
    in=l
    rename=(id=l_id)
  )
;
by mandant generation;
if l and last.generation
then if id > l_id
then call execute(cats('%nrstr(%yourmac(',mandant,",",generation,",",id,",",l_id,'))'));
run;