topic Re: PROC SUMMARY DATA in New SAS User https://communities.sas.com/t5/New-SAS-User/PROC-SUMMARY-DATA/m-p/619119#M19340 <P>Thank you so much <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 22 Jan 2020 12:20:10 GMT sanjaymane7 2020-01-22T12:20:10Z PROC SUMMARY DATA https://communities.sas.com/t5/New-SAS-User/PROC-SUMMARY-DATA/m-p/619077#M19331 <P>Hi, I am using proc summary data statement where I don't want '_FREQ_ ','_TYPE_' and 'Total' (Blank) in output/ result.</P><P>&nbsp;</P><P>received below result from SAS</P><P>&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P>TransactionId</P></TD><TD><P>_FRQ_</P></TD><TD><P>_TYPE_</P></TD><TD><P>COMMISSION</P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P></TD></TR><TR><TD><P>A1234</P></TD><TD><P>0</P></TD><TD><P>1</P></TD><TD><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80</P></TD></TR><TR><TD><P>B1234</P></TD><TD><P>0</P></TD><TD><P>1</P></TD><TD><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Want result as per below&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>TransactionId</TD><TD>COMMISSION</TD></TR><TR><TD>A1234</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80</TD></TR><TR><TD>B1234</TD><TD>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</TD></TR></TBODY></TABLE><P>&nbsp;</P> Wed, 22 Jan 2020 09:58:51 GMT https://communities.sas.com/t5/New-SAS-User/PROC-SUMMARY-DATA/m-p/619077#M19331 sanjaymane7 2020-01-22T09:58:51Z Re: PROC SUMMARY DATA https://communities.sas.com/t5/New-SAS-User/PROC-SUMMARY-DATA/m-p/619079#M19333 <P>2 steps:</P> <P>&nbsp;</P> <P>1. Use the nway option in the PROC Statement.</P> <P>2. Drop the two variables from the output data.</P> <P>&nbsp;</P> <P>See below</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">proc summary nway; /* other code */; output out = want(drop=_:); run;</CODE></PRE> Wed, 22 Jan 2020 10:06:45 GMT https://communities.sas.com/t5/New-SAS-User/PROC-SUMMARY-DATA/m-p/619079#M19333 PeterClemmensen 2020-01-22T10:06:45Z Re: PROC SUMMARY DATA https://communities.sas.com/t5/New-SAS-User/PROC-SUMMARY-DATA/m-p/619119#M19340 <P>Thank you so much <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 22 Jan 2020 12:20:10 GMT https://communities.sas.com/t5/New-SAS-User/PROC-SUMMARY-DATA/m-p/619119#M19340 sanjaymane7 2020-01-22T12:20:10Z Re: PROC SUMMARY DATA https://communities.sas.com/t5/New-SAS-User/PROC-SUMMARY-DATA/m-p/619122#M19341 <P>Anytime <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Wed, 22 Jan 2020 12:35:01 GMT https://communities.sas.com/t5/New-SAS-User/PROC-SUMMARY-DATA/m-p/619122#M19341 PeterClemmensen 2020-01-22T12:35:01Z