topic Re: Proc Export in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Proc-Export/m-p/87603#M24996 <HTML><HEAD></HEAD><BODY><P>Easy.</P><P></P><P></P><P>proc export data=sashelp.class outfile='c:\temp\x.xls' dbms=excel replace;sheet='class';run;</P><P>proc export data=sashelp.air outfile='c:\temp\x.xls' dbms=excel replace;sheet='air';run;</P><P></P><P></P><P></P><P></P><P></P><P>Ksharp</P></BODY></HTML> Mon, 03 Dec 2012 04:57:29 GMT Ksharp 2012-12-03T04:57:29Z Proc Export https://communities.sas.com/t5/SAS-Procedures/Proc-Export/m-p/87601#M24994 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>How to export multiple datasets to a single Excel file and arranging them as Work sheets using proc export.</P><P></P><P></P><P>Regards,</P><P>Sravan</P></BODY></HTML> Sun, 02 Dec 2012 07:45:16 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-Export/m-p/87601#M24994 sravanpathu 2012-12-02T07:45:16Z Re: Proc Export https://communities.sas.com/t5/SAS-Procedures/Proc-Export/m-p/87602#M24995 <HTML><HEAD></HEAD><BODY><P>Do you license SAS/Access for pcfile formats, what version of SAS are you using, what kind of computer are you using, and is it 32 or 64 bit?</P></BODY></HTML> Sun, 02 Dec 2012 15:32:58 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-Export/m-p/87602#M24995 art297 2012-12-02T15:32:58Z Re: Proc Export https://communities.sas.com/t5/SAS-Procedures/Proc-Export/m-p/87603#M24996 <HTML><HEAD></HEAD><BODY><P>Easy.</P><P></P><P></P><P>proc export data=sashelp.class outfile='c:\temp\x.xls' dbms=excel replace;sheet='class';run;</P><P>proc export data=sashelp.air outfile='c:\temp\x.xls' dbms=excel replace;sheet='air';run;</P><P></P><P></P><P></P><P></P><P></P><P>Ksharp</P></BODY></HTML> Mon, 03 Dec 2012 04:57:29 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-Export/m-p/87603#M24996 Ksharp 2012-12-03T04:57:29Z Re: Proc Export https://communities.sas.com/t5/SAS-Procedures/Proc-Export/m-p/87604#M24997 <HTML><HEAD></HEAD><BODY><P>SAS EG 4.3 </P><P>We had access for PC Files.</P><P>32bit</P></BODY></HTML> Mon, 03 Dec 2012 14:54:22 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-Export/m-p/87604#M24997 sravanpathu 2012-12-03T14:54:22Z Re: Proc Export https://communities.sas.com/t5/SAS-Procedures/Proc-Export/m-p/87605#M24998 <HTML><HEAD></HEAD><BODY><P>Thank you </P><P></P><P>If i want to replace only Air Sheet&nbsp; then what i have to do</P></BODY></HTML> Mon, 03 Dec 2012 14:59:35 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-Export/m-p/87605#M24998 sravanpathu 2012-12-03T14:59:35Z Re: Proc Export https://communities.sas.com/t5/SAS-Procedures/Proc-Export/m-p/87606#M24999 <HTML><HEAD></HEAD><BODY><P>Just run the code again, air sheet will be updated .</P></BODY></HTML> Tue, 04 Dec 2012 02:04:33 GMT https://communities.sas.com/t5/SAS-Procedures/Proc-Export/m-p/87606#M24999 Ksharp 2012-12-04T02:04:33Z