I am new to SAS I have a dataset created in redcap. it has been imported into SAS studio as a csv file it is patient data and the goal is to determine if patients who identify as transgender/Non binary have a rate of surgical complications less than, equal to, or higher than patients who identify as cisgender when it comes to hysterectomy for each patient I have collected information about whether they had an intraoperative complication, postoperative complication, reoperation, or readmission For Intraoperative complications there are 5 different complications being looked at intraop_complication__1 (vascular injury), intraop_complication__2 (GI injury), intraop_complications___4 ('Intraoperative consult due to complication), label intraop_complications___97(Other). For postop the data is similar with 1-8, 97. for reoperation and for readmission it's either yes or no I want to create a composite variable. Its name will be surgical complications. It will be a column that shows either a Yes or No. It will be Yes if a patient had any complication (any single positive value in the intraop, postop, reoperation, or readmission categories) or No (no positive value for any of the aforementioned categories) I have tried if-then statements with or/and, if then else statements, array statements and I cannot get this to work. I got it close to working but then it stopped and started just putting a "." and I could not figure out why it stopped working. I am at my wits end and willing to pay someone to help me at this point (if that is allowed). Any suggestions (or takers to hop on zoom and try to help me figure it out for compensation?) data WORK.REDCAP; infile datalines dsd truncover; input record_id:$500. age:BEST12. gender:GENDER_. gender_other:$500. bmi:BEST12. race___1:RACE___1_. race___2:RACE___2_. race___3:RACE___3_. race___4:RACE___4_. race___5:RACE___5_. ethnicity:ETHNICITY_. insurance:INSURANCE_. testosterone_use:TESTOSTERONE_USE_. dx_hyst:DX_HYST_. dx_hyst_oth:$500. route_hyst:ROUTE_HYST_. asa_class:ASA_CLASS_. oophorectomy:OOPHORECTOMY_. comorbid_conditions___1:COMORBID_CONDITIONS___1_. comorbid_conditions___2:COMORBID_CONDITIONS___2_. comorbid_conditions___3:COMORBID_CONDITIONS___3_. comorbid_conditions___4:COMORBID_CONDITIONS___4_. comorbid_conditions___5:COMORBID_CONDITIONS___5_. comorbid_conditions___6:COMORBID_CONDITIONS___6_. comorbid_conditions___7:COMORBID_CONDITIONS___7_. comorbid_conditions___8:COMORBID_CONDITIONS___8_. comorbid_conditions___9:COMORBID_CONDITIONS___9_. comorbid_conditions___10:COMORBID_CONDITIONS___10_. comorbid_conditions___11:COMORBID_CONDITIONS___11_. smoking:SMOKING_. preop_hematocrit:$500. hx_abnormal_pap:HX_ABNORMAL_PAP_. cystoscopy:CYSTOSCOPY_. cystoscopy_normal:CYSTOSCOPY_NORMAL_. intraop_complications___1:INTRAOP_COMPLICATIONS___1_. intraop_complications___2:INTRAOP_COMPLICATIONS___2_. intraop_complications___3:INTRAOP_COMPLICATIONS___3_. intraop_complications___4:INTRAOP_COMPLICATIONS___4_. intraop_complications___97:INTRAOP_COMPLICATIONS___97_. intraop_complications_other:$500. operative_time:BEST12. postop_complications___1:POSTOP_COMPLICATIONS___1_. postop_complications___2:POSTOP_COMPLICATIONS___2_. postop_complications___3:POSTOP_COMPLICATIONS___3_. postop_complications___4:POSTOP_COMPLICATIONS___4_. postop_complications___5:POSTOP_COMPLICATIONS___5_. postop_complications___6:POSTOP_COMPLICATIONS___6_. postop_complications___7:POSTOP_COMPLICATIONS___7_. postop_complications___8:POSTOP_COMPLICATIONS___8_. postop_complications___97:POSTOP_COMPLICATIONS___97_. postop_complications_oth:$500. reoperation:REOPERATION_. readmission:READMISSION_. data_collection_complete:DATA_COLLECTION_COMPLETE_. gender_01_:GENDER_01_. race:$30.; datalines4; 1,29,Transgender,,36.72,No,No,yes,No,No,Not Hispanic or Latino or Spanish Origin,Public,Yes,Gender Dysphoria,,LAVH,2,Yes,No,No,No,No,No,No,No,No,No,No,No,Never smoked a single cigarette,44.9,No,No,,No,No,No,No,No,,211,No,No,No,No,No,No,No,No,No,,No,No,Complete,gender diverse,Black 2,38,Transgender,,24.28,No,No,yes,No,No,Not Hispanic or Latino or Spanish Origin,Public,Yes,Uterine Fibroids,,Open,2,No,No,No,No,No,No,No,No,No,No,No,No,Never smoked a single cigarette,48.2,No,Yes,Yes,No,No,No,No,No,,267,No,No,No,No,No,No,yes,No,No,,No,No,Complete,gender diverse,Black 3,25,Transgender,,28.7,No,No,No,No,yes,Not Hispanic or Latino or Spanish Origin,Private,Yes,Gender Dysphoria,,TLH,2,Yes,No,No,No,No,No,No,No,No,No,No,No,Smoke very sporadically and/or on rare occasions,39.7,No,Yes,Yes,No,No,No,No,No,,166,No,No,No,No,No,No,No,No,No,,No,No,Complete,gender diverse,White 4,50,Transgender,,29.66,No,No,No,No,yes,Not Hispanic or Latino or Spanish Origin,Private,Yes,Pelvic Pain,,TLH,2,Yes,No,No,No,No,No,No,No,No,No,No,No,Never smoked a single cigarette,56.2,No,Yes,Yes,No,No,No,No,No,,207,No,No,No,No,No,No,No,No,No,,No,No,Complete,gender diverse,White 5,43,Transgender,,34.4,No,No,No,No,yes,Not Hispanic or Latino or Spanish Origin,Public,Yes,Pelvic Pain,,TVH,3,Yes,No,No,No,No,yes,No,No,No,No,No,No,Currently smokes,53.2,No,No,,No,No,No,No,No,,231,No,No,No,No,No,No,No,No,No,,No,No,Complete,gender diverse,White
... View more