Here you go. ... View more

Thanks Reeza     ... View more

Hi Novinosrin and thanks for your help. Sorry for the delayed response but it was a long weekend here where I am. I brought in the old data and ran it against the new data using the code you provided. It creates and populates a column in my results but its putting a "N" in every row even though I know there are some that should have a "Y". I am not very versed with complex code as I basically just run a standard and saved script so some of the code you use I don't really understand.   I used this: data UrineAnalysis1; if _n_=1 then do; if 0 then set Apr2018_TEST; (The old data I imported in) dcl hash H (dataset:'Apr2018_TEST',multidata:'N') ; h.definekey ('COMBO'); h.definedone () ; end; set UrineAnalysis; (the new data created) if h.check()=0 then RETRACT='N'; else RETRACT='Y'; run; ... View more

BTW, the tab labeled "OLD" is the tab to look at. Ignore tab labeled 'NEW" as it was included in the "OLD" tab. Thx ... View more

Thanks Reeza   Thats exactly what I am trying to do. I will close this out and start a new one. Thanks for all your help. ... View more

Thanks Patrick   That is an excellent idea. But for the first time I imported the previous month. I am looking at a page online which shows how to compare the two tables, but it just highlighting the lines on the new table that do not exist on the old. I want to be able to compare the lists and if a line item is on the old table I want a prexisting column in the new table to populate with "Y" or "N". Is that possible or would that have to be done manually? ... View more

That is correct. I am trying to tally all of the unique dates of service per MEMNO, NOT the total amount of lines per MEMNO ... View more

I will try to post it on here   MEMNO COUNT UNIQDOS BEGDATE 1234 1 1 02/16/18 2345 1 1 02/05/18 2345   0 02/05/18 2345 2 1 03/26/18 2345   0 03/26/18 3456 1 1 03/08/18 4567 1 1 03/07/18 4567   0 03/07/18 4567 2 1 03/29/18 4567   0 03/29/18 5678 1 1 03/08/18 5678 2 1 03/11/18 6789 1 1 01/08/18 6789   0 01/08/18 7890 1 1 03/22/18 7890   0 03/22/18 7890 2 1 04/11/18 7890   0 04/11/18   Its coming out as:   MEMNO COUNT UNIQDOS BEGDATE 1234 1 1 02/16/18 2345 1 1 02/05/18 2345 2 0 02/05/18 2345 3 1 03/26/18 2345 4 0 03/26/18 3456 1 1 03/08/18 4567 1 1 03/07/18 4567 2 0 03/07/18 4567 3 1 03/29/18 4567 4 0 03/29/18 5678 1 1 03/08/18 5678 2 1 03/11/18 6789 1 1 01/08/18 6789 2 0 01/08/18 7890 1 1 03/22/18 7890 2 0 03/22/18 7890 3 1 04/11/18 7890 4 0 04/11/18 ... View more

The attached on the above post is the desired outcome ... View more

This is the code I ran and I attached an excel file   data Results1; set Results; by memno combo; if first.memno then count=0; count + 1; UNIQDOS = first.combo; run;       ... View more

I take that back..it didnt work perfectly. It should only count the UNIQDOS in the MEMNO grouping not the number of lines within the MEMNO grouping. There are 4 lines in a grouping but only 2 UNIQDOS, etc. ... View more

That worked perfectly!! Thanks Reeza. Now I have to work on the second stage which is to eliminate all the MEMNO's that have less than a 20 count. ... View more

  Before I was aware you responded, I was experimenting with one of the examples in the tutorial and used the following after creating a new column called combo which combines the MEMNO and the BEGDATE and used:   data Results1; set Results; count + 1; by combo; if first.combo then UNIQDOS = 1; run;   I was pleasantly suprised that the results came out with the UNIQ DOS correctly but the count was a continuos count and did not restart at the new MEMNO (see attached).     ... View more