I have a patient dataset where variables dx_code1-dx_code41 represent 41 diagnosis code variables.  My objective is to output only observations in which at least one of the 41 diagnosis codes matches a particular code.  I have 20 codes in mind, and I am trying to find an efficient way to program this in SAS.  I am trying to set up a macro variable that is a list of constants, but the following code does not work: %let codes = '78060', '7784', '4659', '07999', '46611', '77989', '5990', '53081', '27651', '77189', '44619', '77982', '77931', '7746', 'V290', '77182', '7755', 'V070', '6910', '78791'; data patients; array a_dx dx_code1-dx_code41; do j = 1 to 20;   flag = 0;   do i = 1 to dim(a_dx);        if a_dx(i) in: codes(j) then flag = 1;   end;   if flag > 0 then output;   drop i flag; end; run; Any suggestions?  Thanks! ... View more

I have a health care discharge dataset where each row represents a lab.  There are unique identifiers for the episode of care (DISCHARGE_ID), and each lab that the patient received during that episode of care is listed (the data is in long format, not wide format).  There is also a variable I created called "Chemistry" that equals 1 if the patient got a chemistry panel.  For example: DISCHARGE_ID             LAB CODE             CHEMISTRY 1                                   12345                     1                                      1                                   12532                     0 2                                   09343                     0 3                                   34341                     0 3                                   12345                     1 3                                   12345                     1 I am trying to create code that creates a list of unique discharge_ID's in which one or more chemistry panels was obtained during the episode of care.  I can see how I might do this if I transposed the data to wide format, but I'm curious how one would do this without transposing.  This is the code I have used: data chemistry; set lab; by discharge_id; if first.discharge_id; where chemistry = 1; run; Does that look right?  Thanks! ... View more

Hello - I'm analyzing a healthcare claims database with one row per discharge.  Each row has 41 variables representing 41 discharge diagnosis codes (variables dx_code1-dx_code41).  I am trying to identify all discharges with one of four diagnosis codes.  I could manually type this out but I'm sure there must be a more elegant way (macro?) to do this.  Any help would be appreciated.  Thanks! data discharges; where dx_code1 in: ('0199', '7806', '78034', '7213') or dx_code2 in: ('0199', '7806', '78034', '7213') or ... dx_code41 in: ('0199', '7806', '78034', '7213'); run; ... View more