https://communities.sas.com/t5/SAS-Programming/What-would-be-the-procedure-similar-to-making-a-excel-pivot/m-p/338545#M77115 <P>It depends. There are many different ways starting from:</P> <P>&nbsp;</P> <UL> <LI>Proc Means, Summary, Univariate</LI> <LI>Proc Report</LI> <LI>Proc Tabulate</LI> <LI>Proc Freq</LI> <LI>SurveyFreq or SurveyMeans&nbsp;</LI> </UL> <P>All of these Procs have examples in the documentation.&nbsp;</P> <P>&nbsp;</P> <P>I would probably start with Proc Tabulate as it's pretty versatile.&nbsp;</P> <P>Here's a paper with examples</P> <P><A href="http://www.lexjansen.com/scsug/2007/how/HOW-Winn.pdf" target="_blank">http://www.lexjansen.com/scsug/2007/how/HOW-Winn.pdf</A></P> Mon, 06 Mar 2017 19:24:55 GMT Reeza 2017-03-06T19:24:55Z https://communities.sas.com/t5/SAS-Programming/What-would-be-the-procedure-similar-to-making-a-excel-pivot/m-p/338538#M77112 <P><SPAN>What would be the procedure similar to making a excel pivot table</SPAN>?</P><P>I need 2 examples ones<SPAN class="short_text"><SPAN>Summarizing and other counting</SPAN></SPAN></P> Mon, 06 Mar 2017 19:06:07 GMT https://communities.sas.com/t5/SAS-Programming/What-would-be-the-procedure-similar-to-making-a-excel-pivot/m-p/338538#M77112 Angel_Saenz 2017-03-06T19:06:07Z https://communities.sas.com/t5/SAS-Programming/What-would-be-the-procedure-similar-to-making-a-excel-pivot/m-p/338545#M77115 <P>It depends. There are many different ways starting from:</P> <P>&nbsp;</P> <UL> <LI>Proc Means, Summary, Univariate</LI> <LI>Proc Report</LI> <LI>Proc Tabulate</LI> <LI>Proc Freq</LI> <LI>SurveyFreq or SurveyMeans&nbsp;</LI> </UL> <P>All of these Procs have examples in the documentation.&nbsp;</P> <P>&nbsp;</P> <P>I would probably start with Proc Tabulate as it's pretty versatile.&nbsp;</P> <P>Here's a paper with examples</P> <P><A href="http://www.lexjansen.com/scsug/2007/how/HOW-Winn.pdf" target="_blank">http://www.lexjansen.com/scsug/2007/how/HOW-Winn.pdf</A></P> Mon, 06 Mar 2017 19:24:55 GMT https://communities.sas.com/t5/SAS-Programming/What-would-be-the-procedure-similar-to-making-a-excel-pivot/m-p/338545#M77115 Reeza 2017-03-06T19:24:55Z https://communities.sas.com/t5/SAS-Programming/What-would-be-the-procedure-similar-to-making-a-excel-pivot/m-p/338551#M77117 <P>On the other hand, if you're on a system that can run VB Script (e.g., any version of Windows) you can use SAS to create an Excel pivot table for you. For some sample code, take a look at:&nbsp;<A href="https://listserv.uga.edu/cgi-bin/wa?A2=ind0506a&amp;L=SAS-L&amp;O=D&amp;F=P&amp;X=FB41D225061C8C7F9B&amp;P=62191" target="_blank" rel="nofollow noopener noreferrer">https://listserv.uga.edu/cgi-bin/wa?A2=ind0506a&amp;L=<WBR />SAS-L&amp;O=D&amp;F=P&amp;X=FB41D225061C8C7F9B&amp;P=62191</A></P> <P>&nbsp;</P> <P>Art, CEO, AnalystFinder.com</P> <P>&nbsp;</P> Mon, 06 Mar 2017 19:50:42 GMT https://communities.sas.com/t5/SAS-Programming/What-would-be-the-procedure-similar-to-making-a-excel-pivot/m-p/338551#M77117 art297 2017-03-06T19:50:42Z