The source is excel, here is the code my former colleague wrote to import them in:
/*import data from excel that the team has reviewed to SAS dataset*/ %MACRO CheckExcel(ex=, tab=); PROC IMPORT OUT=WORK.&tab /*DATAFILE= "\\hospital patient data\Hosp_Death_Report\ team notes\&ex..xlsx"*/ DATAFILE= "\\hospital patient data\Hosp_Match\QA\Data\ team notes\&ex..xlsx" DBMS=EXCEL REPLACE; RANGE="&tab$"; GETNAMES=YES; MIXED=NO; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; %MEND CheckExcel; %CheckExcel(ex=QA_ICU_Intub_X2_09SEP2021, tab=QA_IcuInt_09SEP2021); %CheckExcel(ex=QA_ICU_Intub_X3_15SEP2021, tab=QA_IcuInt_15SEP2021); %CheckExcel(ex=QA_ICU_Intub_Xx1_22SEP2021,tab=QA__IcuInt_Other_22SEP2021);
... View more