https://communities.sas.com/t5/SAS-Programming/how-to-output-patient-profile-in-one-excel-file/m-p/696078#M212531 <P>Hi,</P><P>&nbsp;</P><P>Currently, I am outputting ods pdf for multiple subjects for a patient profile listing.&nbsp; What is the best way to convert that into one excel file with multiple sheets as subjects? Should I use ods excel or proc export?</P> Tue, 03 Nov 2020 02:37:26 GMT HitmonTran 2020-11-03T02:37:26Z https://communities.sas.com/t5/SAS-Programming/how-to-output-patient-profile-in-one-excel-file/m-p/696078#M212531 <P>Hi,</P><P>&nbsp;</P><P>Currently, I am outputting ods pdf for multiple subjects for a patient profile listing.&nbsp; What is the best way to convert that into one excel file with multiple sheets as subjects? Should I use ods excel or proc export?</P> Tue, 03 Nov 2020 02:37:26 GMT https://communities.sas.com/t5/SAS-Programming/how-to-output-patient-profile-in-one-excel-file/m-p/696078#M212531 HitmonTran 2020-11-03T02:37:26Z https://communities.sas.com/t5/SAS-Programming/how-to-output-patient-profile-in-one-excel-file/m-p/696099#M212546 <P>proc export only creates one sheet.</P> <P>Use ODS. And search for the numerous examples available.</P> Tue, 03 Nov 2020 05:43:08 GMT https://communities.sas.com/t5/SAS-Programming/how-to-output-patient-profile-in-one-excel-file/m-p/696099#M212546 ChrisNZ 2020-11-03T05:43:08Z