https://communities.sas.com/t5/SAS-Programming/How-to-extract-and-copy-a-specific-sheet-in-an-Excel-file-to/m-p/876974#M346441 <P>You could read the sheet into a SAS data set and then use SAS to write a brand new spreadsheet in another folder. CAUTION: not all features in Excel can be copied this way.</P> Mon, 22 May 2023 21:31:24 GMT PaigeMiller 2023-05-22T21:31:24Z https://communities.sas.com/t5/SAS-Programming/How-to-extract-and-copy-a-specific-sheet-in-an-Excel-file-to/m-p/876973#M346440 <P>Although this thread (<A href="https://communities.sas.com/t5/SAS-Programming/Copy-Excel-file-from-one-folder-to-another/m-p/418901#M280437" target="_blank">https://communities.sas.com/t5/SAS-Programming/Copy-Excel-file-from-one-folder-to-another/m-p/418901#M280437</A>) was helpful about how to copy an Excel file from one folder to another with SAS, is there a way to copy a specific sheet in an Excel file with multiple sheets to another folder with SAS? I'm using SAS 9.4.</P> Mon, 22 May 2023 21:22:29 GMT https://communities.sas.com/t5/SAS-Programming/How-to-extract-and-copy-a-specific-sheet-in-an-Excel-file-to/m-p/876973#M346440 BigPete 2023-05-22T21:22:29Z https://communities.sas.com/t5/SAS-Programming/How-to-extract-and-copy-a-specific-sheet-in-an-Excel-file-to/m-p/876974#M346441 <P>You could read the sheet into a SAS data set and then use SAS to write a brand new spreadsheet in another folder. CAUTION: not all features in Excel can be copied this way.</P> Mon, 22 May 2023 21:31:24 GMT https://communities.sas.com/t5/SAS-Programming/How-to-extract-and-copy-a-specific-sheet-in-an-Excel-file-to/m-p/876974#M346441 PaigeMiller 2023-05-22T21:31:24Z https://communities.sas.com/t5/SAS-Programming/How-to-extract-and-copy-a-specific-sheet-in-an-Excel-file-to/m-p/876978#M346442 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/10892">@PaigeMiller</a>&nbsp;but any idea how to preserve original formats?</P> <P>&nbsp;</P> <P>Any idea how to keep this appearance into the target copy?</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BigPete_0-1684792879118.png" style="width: 151px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/84189i87711F0C04C950DC/image-dimensions/151x221?v=v2" width="151" height="221" role="button" title="BigPete_0-1684792879118.png" alt="BigPete_0-1684792879118.png" /></span></P> <P>&nbsp;</P> <P>Don't want the copy to look like this:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BigPete_1-1684792957331.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/84190i627363124060142A/image-size/medium?v=v2&amp;px=400" role="button" title="BigPete_1-1684792957331.png" alt="BigPete_1-1684792957331.png" /></span></P> <P>&nbsp;</P> <P>And any idea if there's a way in SAS to extract a specific sheet in a multi-sheet Excel file and copy each into separate Excel files?</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="BigPete_2-1684793129964.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/84191iF9C183752107224A/image-size/medium?v=v2&amp;px=400" role="button" title="BigPete_2-1684793129964.png" alt="BigPete_2-1684793129964.png" /></span></P> <P>&nbsp;</P> Mon, 22 May 2023 22:05:45 GMT https://communities.sas.com/t5/SAS-Programming/How-to-extract-and-copy-a-specific-sheet-in-an-Excel-file-to/m-p/876978#M346442 BigPete 2023-05-22T22:05:45Z https://communities.sas.com/t5/SAS-Programming/How-to-extract-and-copy-a-specific-sheet-in-an-Excel-file-to/m-p/876979#M346443 <P>If you really have to preserve the formats, then look at Visual Basic. I don't think that SAS is the right tool for this.</P> Mon, 22 May 2023 22:23:55 GMT https://communities.sas.com/t5/SAS-Programming/How-to-extract-and-copy-a-specific-sheet-in-an-Excel-file-to/m-p/876979#M346443 PaigeMiller 2023-05-22T22:23:55Z