Hello,   I am trying to use Hash Object to create a dataset Want. I want to be able to join datasets work.Small and SAS.BIG on ID.    Getting an error at Code Line do unitil (eof);                     /* Error Message : Expecting an =. */   Need help in identifying what is wrong with the code. I am sorry but the database is quite big and I won't be able to provide details using INFILE option.   The same do until code works in first step but it doesn't work when I use dataset from SAS library in second do until step. Is it possible to identify the error with no data information ?   Here's the code I am using:       data Want; declare hash Sub(hashexp:7); Sub.definekey('ID'); Sub.definedata('n'); Sub.definedone(); do until (eof_Small); set Small end=eof_Small n+1; Sub.add(); end;   do unitl (eof);                                                                                                     /*Getting an error here that : Expecting an =. */ set SAS.BIG end=eof ;   if Sub.find()=0 then do; set Small point=n; output; end; stop; ... View more

Hello,   I want to subset the Input Table by comparing the Service Date of each Customer_ID. If difference in Service Date of a Customer_ID is within 7 days, then select only the observation with oldest date. If difference in Service Date is more than 7 days then select all the observations. Please see the Input and Output Tables below and help me with the Code.                                    Input Table Customer_ID Transaction_ID Service Date AB1 12345 10/12/18 AB1 12346 10/14/18 AB1 12347 10/15/18 AB2 22233 6/10/18 AB2 22234 9/12/18 AB3 35678 1/5/19                                 Output Table Customer_ID Transaction_ID Service Date AB1 12345 10/12/18 AB2 22233 6/10/18 AB2 22234 9/12/18 AB3 35678 1/5/19   Thanks, Varun ... View more