topic Need a pivot kind of output on a sas dataset in SAS Procedures

topic Need a pivot kind of output on a sas dataset in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Need-a-pivot-kind-of-output-on-a-sas-dataset/m-p/187651#M47594 <HTML><HEAD></HEAD><BODY><H6><SPAN style="font-size: 8pt;">D/All,</SPAN></H6><H6></H6><H6><SPAN style="font-size: 8pt;">I have a below sample dataset -</SPAN></H6><H6></H6><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 98px;"><TBODY><TR><TD class="xl63" height="15" width="98"><H6><SPAN style="font-size: 8pt;">field1,field2,status</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST3</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST2</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST4</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST4</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST2</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST3</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST3</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST3</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST3</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST3</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST4</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST3</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST2</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST3</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST2</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST3</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST3</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST2</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST2</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST2</SPAN></H6></TD></TR></TBODY></TABLE><H6></H6><H6><SPAN style="font-size: 8pt;">Need to create similar freq dataset.</SPAN></H6><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 142px;"><TBODY><TR><TD class="xl65" height="15" width="142"><H6><SPAN style="font-size: 8pt;"><STRONG>field1,field2,ST1,ST2,ST3,ST4</STRONG></SPAN></H6></TD></TR><TR><TD class="xl65" height="15"><H6><SPAN style="font-size: 8pt;"><STRONG>AM1,BM1,9,2,4,2</STRONG></SPAN></H6></TD></TR><TR><TD class="xl65" height="15"><H6><SPAN style="font-size: 8pt;"><STRONG>AM1,BM2,5,5,6,1</STRONG></SPAN></H6></TD></TR></TBODY></TABLE><H6></H6><H6><SPAN style="font-size: 8pt;">I cannot attach any excel data hence the input and output both are in CSV format. Request if anyone can provide me a way to create this format output.</SPAN></H6><H6><SPAN style="font-size: 8pt;">For now ST1, ST2, ST3, ST4 are fixed observations but need a code which dynamically creates the output variables.</SPAN></H6><H6></H6><H6><SPAN style="font-size: 8pt;">Thanks a lot,</SPAN></H6><H6></H6><H6><SPAN style="font-size: 8pt;">Rgds, Anil</SPAN></H6><H6></H6><H6><SPAN style="font-size: 8pt;">.</SPAN></H6></BODY></HTML> Mon, 02 Mar 2015 02:01:43 GMT aj34321 2015-03-02T02:01:43Z Need a pivot kind of output on a sas dataset https://communities.sas.com/t5/SAS-Procedures/Need-a-pivot-kind-of-output-on-a-sas-dataset/m-p/187651#M47594 <HTML><HEAD></HEAD><BODY><H6><SPAN style="font-size: 8pt;">D/All,</SPAN></H6><H6></H6><H6><SPAN style="font-size: 8pt;">I have a below sample dataset -</SPAN></H6><H6></H6><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 98px;"><TBODY><TR><TD class="xl63" height="15" width="98"><H6><SPAN style="font-size: 8pt;">field1,field2,status</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST3</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST2</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST4</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST4</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST2</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST3</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST3</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM1,ST3</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST3</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST3</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST4</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST3</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST2</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST3</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST2</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST3</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST3</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST2</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST2</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST1</SPAN></H6></TD></TR><TR><TD class="xl63" height="15"><H6><SPAN style="font-size: 8pt;">AM1,BM2,ST2</SPAN></H6></TD></TR></TBODY></TABLE><H6></H6><H6><SPAN style="font-size: 8pt;">Need to create similar freq dataset.</SPAN></H6><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 142px;"><TBODY><TR><TD class="xl65" height="15" width="142"><H6><SPAN style="font-size: 8pt;"><STRONG>field1,field2,ST1,ST2,ST3,ST4</STRONG></SPAN></H6></TD></TR><TR><TD class="xl65" height="15"><H6><SPAN style="font-size: 8pt;"><STRONG>AM1,BM1,9,2,4,2</STRONG></SPAN></H6></TD></TR><TR><TD class="xl65" height="15"><H6><SPAN style="font-size: 8pt;"><STRONG>AM1,BM2,5,5,6,1</STRONG></SPAN></H6></TD></TR></TBODY></TABLE><H6></H6><H6><SPAN style="font-size: 8pt;">I cannot attach any excel data hence the input and output both are in CSV format. Request if anyone can provide me a way to create this format output.</SPAN></H6><H6><SPAN style="font-size: 8pt;">For now ST1, ST2, ST3, ST4 are fixed observations but need a code which dynamically creates the output variables.</SPAN></H6><H6></H6><H6><SPAN style="font-size: 8pt;">Thanks a lot,</SPAN></H6><H6></H6><H6><SPAN style="font-size: 8pt;">Rgds, Anil</SPAN></H6><H6></H6><H6><SPAN style="font-size: 8pt;">.</SPAN></H6></BODY></HTML> Mon, 02 Mar 2015 02:01:43 GMT https://communities.sas.com/t5/SAS-Procedures/Need-a-pivot-kind-of-output-on-a-sas-dataset/m-p/187651#M47594 aj34321 2015-03-02T02:01:43Z Re: Need a pivot kind of output on a sas dataset https://communities.sas.com/t5/SAS-Procedures/Need-a-pivot-kind-of-output-on-a-sas-dataset/m-p/187652#M47595 <HTML><HEAD></HEAD><BODY><P>1. Run a proc freq to get the counts</P><P>2. Use Proc Transpose to transpose to required format</P></BODY></HTML> Mon, 02 Mar 2015 03:04:49 GMT https://communities.sas.com/t5/SAS-Procedures/Need-a-pivot-kind-of-output-on-a-sas-dataset/m-p/187652#M47595 Reeza 2015-03-02T03:04:49Z