Hello team, I have not tested it. Please give me some time to test it. Blue berry ... View more

Hello, I tested the order of columns and contents from prior month to this month. I can’t see anything is changed and I can’t find the error. Thanks Blue berry ... View more

Hello Tom, Yes, This is what I am looking for. In prior posts, I said no "and" or "or", I was wrong. Can we put the code in a way that if the condition is met, then don't bring that row in to the result. I mean delete that row. Thanks, Bitter & Sweet ... View more

Hello Cynthia, The join is already happened in a proc sql and I'd like the rule for which I showed a table to be applied. I need to add this rule to a proc sql by if statement or case when.   I appreciate your response. Bitter & Sweet ... View more

Hello Cyntia, Thanks for the response.  This is my table in real life: measure                     coveredCalifornia    Medicare    Medicaid HMO measureA                          X                           X              N/A measureB                         N/A                         X              X measureC                        X                              X             N/A   Now, I want the result doesn't show the measure when it is N/A for a healthplan. That is the best I can explain it. Respectfully, Bitter & Sweet.   ... View more

Hello, How can I write this in a code either in if statement or case statement? If lineofbusiness is medicare then measures are measureA, measureB, measurec. Thanks, Bitter & Sweet ... View more

Hello Tom, Invalid measure is taken care of in a different part of the code. Whatever we have is valid measures and valid line of business. Respectfully, bitter & sweet ... View more

Hello Tom, I don't need "and" or "or"   I said if line of business is medicare then measures are measure A, measure B, measure c This is what I want in code.    Respectfully, bitter & sweet     ... View more

Hello, What I am trying to do is when line of business is Medicare, then measures such sas measureA, MeasureB and MeasureC are applied to Medicare line of business.   Should I say? If LineofBusiness eq upcase(Medicare) Then measure in ('measureA', 'measureB', 'Measurec'); If LineofBusiness eq upcase(Commercial) Then measure in ('measureA', 'measureB', 'MeasureD');   Something like above.   I have a proc sql that selects LineofBusiness and measure, I need to add the part on the top to this proc sql.   Thanks, p.s. Each record has one line of business and one measure in the measure field. How do I need to write this code?   Bitter & Sweet.   ... View more

Hello Tom, As simple as I said. None of the cases you said. If I want to explain what our department does, that makes it more complicated and I need to explain about the strategy of United States Health plans.   Some of the insurances don't have all measures. As simple as this.   For example: if LineOfBusiness eq 'Medicare' then measure eq 'measure A' if LineOfBusiness eq 'Medicare' then measure eq 'measure B' or  if LineOfBusiness eq 'Medicare' then measure in ('measure A', 'measure B',..)   I need to add this to a proc sql which is already there. I need to add this part to my code. No need to change the code because that brings more complication. I need to add this part to my code only. Thanks, Bitter & Sweet   ... View more