topic Re: Pivot table in SAS in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Pivot-table-in-SAS/m-p/151220#M39809 <HTML><HEAD></HEAD><BODY><P>Here is another link which may be useful, similar to Reeza's first option:</P><P></P><P><A href="http://support.sas.com/resources/papers/proceedings14/SAS177-2014.pdf">http://support.sas.com/resources/papers/proceedings14/SAS177-2014.pdf</A></P></BODY></HTML> Wed, 06 Aug 2014 19:29:50 GMT SASKiwi 2014-08-06T19:29:50Z Pivot table in SAS https://communities.sas.com/t5/SAS-Procedures/Pivot-table-in-SAS/m-p/151215#M39804 <HTML><HEAD></HEAD><BODY><P> Hi,</P><P></P><P> I am currently manually creating a pivot table using an XLS file and sent it to users. I need to automate it and looking for suggestions. I am using PC SAS.</P><P></P><P></P><P></P><P>Thanks,</P><P><BR /> </P></BODY></HTML> Wed, 06 Aug 2014 14:17:04 GMT https://communities.sas.com/t5/SAS-Procedures/Pivot-table-in-SAS/m-p/151215#M39804 archana 2014-08-06T14:17:04Z Re: Pivot table in SAS https://communities.sas.com/t5/SAS-Procedures/Pivot-table-in-SAS/m-p/151216#M39805 <HTML><HEAD></HEAD><BODY><P>Well, there are two or three options.&nbsp; Unfortunately this is a question which comes up a lot - I have xyz in Excel and I want to do something in SAS then have Excel updated.&nbsp; So some options:</P><P>- Learn Open Office format - this is what is used to store Excel files behind the scenes - rename the XLSX to ZIP and you can see the folders and files.&nbsp; This is really in depth however.</P><P>- Use DDE to send your data out to an existing file - This is old tech and may/may not work in future and isn't straight forward.</P><P>- Save your data from SAS as CSV.&nbsp; Then in your Excel file have a vba macro which imports the CSV data and updates your sheet.</P><P></P><P>As far as I am aware there is no way to create a pivot chart from directly in SAS.&nbsp; The output is for reports only. </P></BODY></HTML> Wed, 06 Aug 2014 14:38:15 GMT https://communities.sas.com/t5/SAS-Procedures/Pivot-table-in-SAS/m-p/151216#M39805 RW9 2014-08-06T14:38:15Z Re: Pivot table in SAS https://communities.sas.com/t5/SAS-Procedures/Pivot-table-in-SAS/m-p/151217#M39806 <HTML><HEAD></HEAD><BODY><P>Do you need to create an actual pivot table and send it out, or a table with information in a specific format?</P></BODY></HTML> Wed, 06 Aug 2014 14:40:49 GMT https://communities.sas.com/t5/SAS-Procedures/Pivot-table-in-SAS/m-p/151217#M39806 Reeza 2014-08-06T14:40:49Z Re: Pivot table in SAS https://communities.sas.com/t5/SAS-Procedures/Pivot-table-in-SAS/m-p/151218#M39807 <HTML><HEAD></HEAD><BODY><P>Like <A __default_attr="814511" __jive_macro_name="user" class="jive_macro jive_macro_user" data-objecttype="3" href="https://communities.sas.com/"></A> suggested, if all you have is Base SAS, then there isn't a straightforward solution for you. However, if you are using SAS EBI and have OLAP Cube studio and SAS Microsofte add-in installed, then it becomes a piece of cake. Pivot table is nothing but a simplified Cube.</P><P></P><P>Haikuo </P></BODY></HTML> Wed, 06 Aug 2014 14:45:10 GMT https://communities.sas.com/t5/SAS-Procedures/Pivot-table-in-SAS/m-p/151218#M39807 haikuobian 2014-08-06T14:45:10Z Re: Pivot table in SAS https://communities.sas.com/t5/SAS-Procedures/Pivot-table-in-SAS/m-p/151219#M39808 <HTML><HEAD></HEAD><BODY><P>This doesn't create a native excel file, and I think its ugly but its a solution:</P><P><A class="active_link" href="http://support.sas.com/rnd/base/ods/odsmarkup/tableeditor/" title="http://support.sas.com/rnd/base/ods/odsmarkup/tableeditor/">Base SAS: Creating a Data Grid Like VB.NET</A></P><P></P><P>Excel Hacks:</P><P>Create the excel file manually (once). Update the data via an export. When user opens the workbook they will have to refresh (usually via a pop up), or embed a macro or script in the workbook to automatically open on refresh.</P><P></P><P>DDE: Combination of export and then refresh using DDE</P><P><A __default_attr="213247" __jive_macro_name="message" class="jive_macro jive_macro_message active_link" href="https://communities.sas.com/" modifiedtitle="true" title="Re: Automating Excel pivot table in SAS"></A></P></BODY></HTML> Wed, 06 Aug 2014 15:30:33 GMT https://communities.sas.com/t5/SAS-Procedures/Pivot-table-in-SAS/m-p/151219#M39808 Reeza 2014-08-06T15:30:33Z Re: Pivot table in SAS https://communities.sas.com/t5/SAS-Procedures/Pivot-table-in-SAS/m-p/151220#M39809 <HTML><HEAD></HEAD><BODY><P>Here is another link which may be useful, similar to Reeza's first option:</P><P></P><P><A href="http://support.sas.com/resources/papers/proceedings14/SAS177-2014.pdf">http://support.sas.com/resources/papers/proceedings14/SAS177-2014.pdf</A></P></BODY></HTML> Wed, 06 Aug 2014 19:29:50 GMT https://communities.sas.com/t5/SAS-Procedures/Pivot-table-in-SAS/m-p/151220#M39809 SASKiwi 2014-08-06T19:29:50Z