11-19-2014 11:41 AM
I have Medicaid data, and there is a separate line for the category of each diagnosis (DX_cat) given at a visit to a doctor. I want to combine all of those diagnoses into a single line for each visit. Keep in mind that this requires combining with respect to ID (Encrpt_ID) AND date of service (ClaimDOS). I've found various methods to combine with respect to a single variable, but none for multiple variables. I'm guessing that SQL would be best for this, but I'm open to whatever works. I believe that the number of diagnoses that can be given at a single visit is limited to 9.
The input data looks like this:
The output should look like this:
Need further help from the community? Please ask a new question.