topic Re: Generate log error in SAS Programming

Generate log error

Aayushi_17 — Thu, 17 Jan 2019 09:58:42 GMT

How to generate error in log for duplicte records

Re: Generate log error

PeterClemmensen — Thu, 17 Jan 2019 10:14:04 GMT

How big is your data set?

Re: Generate log error

PeterClemmensen — Thu, 17 Jan 2019 10:21:08 GMT

There are several ways to approach a problem like this. Here is one using the hash object

data testdata(drop=i j);
   array vars var1-var3;
   do i=1 to 100;
      do j=1 to dim(vars);
         vars[j]=rand('integer', 1, 10);
      end;
      output;
   end;
run;

data test2;
   if _N_ = 1 then do;
      declare hash h();
      h.defineKey('var1', 'var2', 'var3');
      h.defineDone();
   end;
 
   set testdata;
 
   rc=h.check();

   if rc=0 then do;
      put 'ERROR: Duplicate Row Detected in Observation No: ' _N_;
      stop;
   end;
   if h.check() ne 0 then do;
      output;
      h.add();
   end;
run;

Re: Generate log error

Aayushi_17 — Thu, 17 Jan 2019 10:29:08 GMT

Thank you so much

Re: Generate log error

Ksharp — Thu, 17 Jan 2019 13:20:42 GMT

data testdata(drop=i j);
   array vars var1-var3;
   do i=1 to 100;
      do j=1 to dim(vars);
         vars[j]=rand('integer', 1, 10);
      end;
      output;
   end;
run;

data _null_;
if 0 then set testdata;
      declare hash h(dataset:'testdata',duplicate:'e');
      h.defineKey('var1', 'var2', 'var3');
      h.defineDone();
run;