Thank you Reeza for  willing to guide. Here is the sample data ,   data merit; input id rating $ rate $ salary ; datalines; 1 A_Exceed A_min 18000 2 B_Meetex B_low 15000 3 C_meetba C_med 19000 4 D_Basic D_hig 22000 5 A_Exceed A_min 18000 6 B_Meetex D_hig 12000 7 A_Exceed A_min 14000 8 B_Meetex D_hig 18000 ; run; proc freq data=merit; tables rating*rate/nopercent norow nocol; run; So we have a departmental budget allocated for merit increase  lets say 25000 Annually we give salary increase (%)  to all employee based on their performance (  here is rating) and salary category ( rate) .  Clause # 1 : The total merit salary increase  for all 8 employee should not exceed more than 25000 budget. Clause #2 : We have to create an algorithm where employee with high performer ( rating = A_ exceed, B_Meetex)  AND also their current salary ( rate = A_min, B_low) should get higher merit percentage while employee who are performing lower ( rating = C_meetba or D_basic) and aslo their  current rate ( = D_high, C_med)  gets lower merit increase. here ID 1, 5 and 7 gets higher  % of merit increase  and  ID 4 gets lowest % merit increase. (a%*18000)+(b%*15000) + (c%*19000) + (d%*22000) + (e%*18000) + (f%*12000) +(g%*14000)+(h%100*18000) <25000     ID =1           ID=2                 ID=3                ID=4              ID=5             ID=6               ID=7            ID=8 here we have to calculate a% b% c% d% e% f% g% h% =?    also ... View more

Thank you so much. Will you please navigate me thru the link or method's name  where I can self learn this process? ... View more

I couldn't paset it in actual sas code but here are my two data sets and the desired outcome data set. Thanks data clinic; input id date mmddyy10. icd; datalines; 1 12/1/2016 493 1 3/1/2018 785 2 5/4/2015 493 2 4/5/2016 651 3 6/4/2017 105 ; run; data ED; input id date mmddyy10. race $ gender$ icd; datalines; 1 1/1/2016 w f 785 1 4/12/2016 w f 493 2 6/4/2015 b m 493 3 7/14/2015 b f 105 3 3/4/2016 b f 359 ; run; data desire; input id date mmddyy10. race$ gender$ icd sameicd$; datalines; 1 1/1/2016 w f 785 yes 1 4/12/2016 w f 493 yes 2 6/4/2015 b m 493 yes 3 7/14/2015 b f 347 no 3 3/4/2016 b f 359 no ; run; ... View more

Thank you Patrik for clarification. I do belive that learning sas will help me tremendously on my job but at this moment  I am just seeking some expert guidance rather that asking somebody to do my job. Also, I did posted the sample data with explanation of what I want. I am reposting this again with  a sample file of desired outcome. I have two data sets ( clinic A and ED visits) Clinic A sample: ID    DATE        ICD 1      12/1           493 1      3/1             785 2      5/4             493 3      6/4            105 . . . ED data sample ID    DATE        ICD 1      1/1           785 1      4/12         493 2      6/4             493 3      7/14          105 . . .   what I am trying to match here is any ED encounter with  ICD codes macthed with the ICD of any encounter of that ID in clinic data set. So on ED  data set I would like to create one variable called "sameicd" where if the ICD on ED data set match with any of the ICD on the cllinic A visits  data set then sameicd=yes, esle sameicd=no for example  the ID 1 in 1/1 date has ICD 785 which matches with the second visit from clinic A in 3/1 then sameicd=yes   desired outcome: ED data sample ID    DATE        ICD  sameicd 1      1/1           785      yes 1      4/12         493      yes 2      6/4             493    yes 3      7/14          105     yes     We do not have NO because all of the ICD on ED  data matches with ICD of Clinic A data . any help will be highly appriciated Thanks   C ... View more

I simply got stuck on some data management so I posted for help.I think you are thinking everyone taking this forum as granted but it's not true.There are some people who just want how to do it rather lifetime lesson ... View more

Yes ..that is why I ask for help ... View more

Sorry I didnot understand what you meant. I was not asking to join the two tables but to create a case if the icd is same to any of the encounter to clinic in any of their visit.. please elaborate more  with actual code  ... View more

Wong, what test should I perform inoder to test the effectiveness of the clinic like ED count reduced by X% from the baseline  Please chare your thoughts ... View more