select 38 as a, "Black or African American" as col, N(distinct PatientID) as pt_num, N(distinct PatientID)/&denom. as Percent from derived._02a_folfiri_demo where new_race='Black or African American' union all
select 39 as a, "White" as col, N(distinct PatientID) as pt_num, N(distinct PatientID)/&denom. as Percent from derived._02a_folfiri_demo where new_race='White' union all It looks like you have an unreadable special character in line 38 "new_race". Try deleting it from your macro code.
... View more