topic Pivot data on export in SAS Studio

topic Pivot data on export in SAS Studio https://communities.sas.com/t5/SAS-Studio/Pivot-data-on-export/m-p/359037#M2515 <P>Hi</P><P> </P><P>I want to piviot the below data in excel on export.</P><P>Any ideas?</P><P>I know how to use proc export etc to do a data cump in excel but how would I pivot the data?</P><P> </P><P> </P><TABLE><TBODY><TR><TD>Col A</TD><TD>Age</TD><TD>Qtr</TD><TD>Gender</TD><TD>Type</TD><TD>Amt</TD></TR><TR><TD>E14</TD><TD>3</TD><TD>Quarter 3 </TD><TD>F</TD><TD>IP</TD><TD>2</TD></TR><TR><TD>E14</TD><TD>5</TD><TD>Quarter 3 </TD><TD>M</TD><TD>IP</TD><TD>1</TD></TR><TR><TD>E14</TD><TD>6</TD><TD>Quarter 3 </TD><TD>F</TD><TD>DC</TD><TD>10</TD></TR><TR><TD>E14</TD><TD>7</TD><TD>Quarter 4</TD><TD>F</TD><TD>IP</TD><TD>1</TD></TR><TR><TD>E14</TD><TD>8</TD><TD>Quarter 4</TD><TD>M</TD><TD>DC</TD><TD>1</TD></TR><TR><TD>E15</TD><TD>3</TD><TD>Quarter 3 </TD><TD>F</TD><TD>IP</TD><TD>2</TD></TR><TR><TD>E15</TD><TD>5</TD><TD>Quarter 3 </TD><TD>M</TD><TD>IP</TD><TD>1</TD></TR><TR><TD>E15</TD><TD>6</TD><TD>Quarter 3 </TD><TD>F</TD><TD>DC</TD><TD>10</TD></TR><TR><TD>E15</TD><TD>7</TD><TD>Quarter 4</TD><TD>F</TD><TD>IP</TD><TD>1</TD></TR><TR><TD>E15</TD><TD>8</TD><TD>Quarter 4</TD><TD>M</TD><TD>DC</TD><TD>1</TD></TR></TBODY></TABLE><P>Expected Output</P><P> </P><P> </P><TABLE><TBODY><TR><TD>Sum of Amt</TD><TD> </TD><TD>Qtr</TD><TD>Gender</TD><TD>Type</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD>Quarter 3 </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>Quarter 3  Total</TD><TD>Quarter 4</TD><TD> </TD><TD> </TD><TD> </TD><TD>Quarter 4 Total</TD><TD>Grand Total</TD></TR><TR><TD> </TD><TD> </TD><TD>F</TD><TD> </TD><TD>F Total</TD><TD>M</TD><TD>M Total</TD><TD> </TD><TD>F</TD><TD>F Total</TD><TD>M</TD><TD>M Total</TD><TD> </TD><TD> </TD></TR><TR><TD>Col A</TD><TD>Age</TD><TD>DC</TD><TD>IP</TD><TD> </TD><TD>IP</TD><TD> </TD><TD> </TD><TD>IP</TD><TD> </TD><TD>DC</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>E14</TD><TD>3</TD><TD> </TD><TD>2</TD><TD>2</TD><TD> </TD><TD> </TD><TD>2</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>2</TD></TR><TR><TD> </TD><TD>5</TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD>1</TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD></TR><TR><TD> </TD><TD>6</TD><TD>10</TD><TD> </TD><TD>10</TD><TD> </TD><TD> </TD><TD>10</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>10</TD></TR><TR><TD> </TD><TD>7</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD>1</TD><TD> </TD><TD> </TD><TD>1</TD><TD>1</TD></TR><TR><TD> </TD><TD>8</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>E15</TD><TD>3</TD><TD> </TD><TD>2</TD><TD>2</TD><TD> </TD><TD> </TD><TD>2</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>2</TD></TR><TR><TD> </TD><TD>5</TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD>1</TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD></TR><TR><TD> </TD><TD>6</TD><TD>10</TD><TD> </TD><TD>10</TD><TD> </TD><TD> </TD><TD>10</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>10</TD></TR><TR><TD> </TD><TD>7</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD>1</TD><TD> </TD><TD> </TD><TD>1</TD><TD>1</TD></TR><TR><TD> </TD><TD>8</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>Grand Total</TD><TD> </TD><TD>20</TD><TD>4</TD><TD>24</TD><TD>2</TD><TD>2</TD><TD>26</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>4</TD><TD>30</TD></TR></TBODY></TABLE> Tue, 16 May 2017 14:16:07 GMT Aidan 2017-05-16T14:16:07Z Pivot data on export https://communities.sas.com/t5/SAS-Studio/Pivot-data-on-export/m-p/359037#M2515 <P>Hi</P><P> </P><P>I want to piviot the below data in excel on export.</P><P>Any ideas?</P><P>I know how to use proc export etc to do a data cump in excel but how would I pivot the data?</P><P> </P><P> </P><TABLE><TBODY><TR><TD>Col A</TD><TD>Age</TD><TD>Qtr</TD><TD>Gender</TD><TD>Type</TD><TD>Amt</TD></TR><TR><TD>E14</TD><TD>3</TD><TD>Quarter 3 </TD><TD>F</TD><TD>IP</TD><TD>2</TD></TR><TR><TD>E14</TD><TD>5</TD><TD>Quarter 3 </TD><TD>M</TD><TD>IP</TD><TD>1</TD></TR><TR><TD>E14</TD><TD>6</TD><TD>Quarter 3 </TD><TD>F</TD><TD>DC</TD><TD>10</TD></TR><TR><TD>E14</TD><TD>7</TD><TD>Quarter 4</TD><TD>F</TD><TD>IP</TD><TD>1</TD></TR><TR><TD>E14</TD><TD>8</TD><TD>Quarter 4</TD><TD>M</TD><TD>DC</TD><TD>1</TD></TR><TR><TD>E15</TD><TD>3</TD><TD>Quarter 3 </TD><TD>F</TD><TD>IP</TD><TD>2</TD></TR><TR><TD>E15</TD><TD>5</TD><TD>Quarter 3 </TD><TD>M</TD><TD>IP</TD><TD>1</TD></TR><TR><TD>E15</TD><TD>6</TD><TD>Quarter 3 </TD><TD>F</TD><TD>DC</TD><TD>10</TD></TR><TR><TD>E15</TD><TD>7</TD><TD>Quarter 4</TD><TD>F</TD><TD>IP</TD><TD>1</TD></TR><TR><TD>E15</TD><TD>8</TD><TD>Quarter 4</TD><TD>M</TD><TD>DC</TD><TD>1</TD></TR></TBODY></TABLE><P>Expected Output</P><P> </P><P> </P><TABLE><TBODY><TR><TD>Sum of Amt</TD><TD> </TD><TD>Qtr</TD><TD>Gender</TD><TD>Type</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD> </TD><TD> </TD><TD>Quarter 3 </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>Quarter 3  Total</TD><TD>Quarter 4</TD><TD> </TD><TD> </TD><TD> </TD><TD>Quarter 4 Total</TD><TD>Grand Total</TD></TR><TR><TD> </TD><TD> </TD><TD>F</TD><TD> </TD><TD>F Total</TD><TD>M</TD><TD>M Total</TD><TD> </TD><TD>F</TD><TD>F Total</TD><TD>M</TD><TD>M Total</TD><TD> </TD><TD> </TD></TR><TR><TD>Col A</TD><TD>Age</TD><TD>DC</TD><TD>IP</TD><TD> </TD><TD>IP</TD><TD> </TD><TD> </TD><TD>IP</TD><TD> </TD><TD>DC</TD><TD> </TD><TD> </TD><TD> </TD></TR><TR><TD>E14</TD><TD>3</TD><TD> </TD><TD>2</TD><TD>2</TD><TD> </TD><TD> </TD><TD>2</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>2</TD></TR><TR><TD> </TD><TD>5</TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD>1</TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD></TR><TR><TD> </TD><TD>6</TD><TD>10</TD><TD> </TD><TD>10</TD><TD> </TD><TD> </TD><TD>10</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>10</TD></TR><TR><TD> </TD><TD>7</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD>1</TD><TD> </TD><TD> </TD><TD>1</TD><TD>1</TD></TR><TR><TD> </TD><TD>8</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>E15</TD><TD>3</TD><TD> </TD><TD>2</TD><TD>2</TD><TD> </TD><TD> </TD><TD>2</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>2</TD></TR><TR><TD> </TD><TD>5</TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD>1</TD><TD>1</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD></TR><TR><TD> </TD><TD>6</TD><TD>10</TD><TD> </TD><TD>10</TD><TD> </TD><TD> </TD><TD>10</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>10</TD></TR><TR><TD> </TD><TD>7</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD>1</TD><TD> </TD><TD> </TD><TD>1</TD><TD>1</TD></TR><TR><TD> </TD><TD>8</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD>1</TD><TD>1</TD><TD>1</TD><TD>1</TD></TR><TR><TD>Grand Total</TD><TD> </TD><TD>20</TD><TD>4</TD><TD>24</TD><TD>2</TD><TD>2</TD><TD>26</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>2</TD><TD>4</TD><TD>30</TD></TR></TBODY></TABLE> Tue, 16 May 2017 14:16:07 GMT https://communities.sas.com/t5/SAS-Studio/Pivot-data-on-export/m-p/359037#M2515 Aidan 2017-05-16T14:16:07Z Re: Pivot data on export https://communities.sas.com/t5/SAS-Studio/Pivot-data-on-export/m-p/359041#M2516 <P>ODS EXCEL + PROC TABULATE </P> Tue, 16 May 2017 14:18:57 GMT https://communities.sas.com/t5/SAS-Studio/Pivot-data-on-export/m-p/359041#M2516 Reeza 2017-05-16T14:18:57Z