topic DATA TRANSPOSE IN SAS in New SAS User https://communities.sas.com/t5/New-SAS-User/DATA-TRANSPOSE-IN-SAS/m-p/563181#M10865 <P>HI team,</P><P>&nbsp;</P><P>I have the table called Customer and data looks like this.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Customer</TD></TR><TR><TD>_TEMA001</TD><TD>PIUM_PCCC</TD><TD>PIUM_PCCD</TD></TR><TR><TD>VV</TD><TD>1</TD><TD>Provider Comprehensive SURS Review</TD></TR><TR><TD>VV</TD><TD>4</TD><TD>MCO Review Outcome Accuracy</TD></TR><TR><TD>VV</TD><TD>7</TD><TD>Beneficiary Death</TD></TR><TR><TD>VV</TD><TD>2</TD><TD>Algorithm Limited Review</TD></TR><TR><TD>VV</TD><TD>5</TD><TD>State-Directed Recovery</TD></TR><TR><TD>VV</TD><TD>8</TD><TD>Provider Death</TD></TR><TR><TD>VV</TD><TD>3</TD><TD>DRA Attestation</TD></TR><TR><TD>VV</TD><TD>6</TD><TD>Excluded Entity</TD></TR><TR><TD>VV</TD><TD>9</TD><TD>Prepayment Review</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need the output of this customer</P><P>&nbsp;</P><P>table into below format by using Proc Transpose.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Output</TD></TR><TR><TD>VV</TD><TD>PIUM_PCCC</TD><TD>1</TD><TD>PIUM_PCCD</TD><TD>Provider Comprehensive SURS Review</TD></TR><TR><TD>VV</TD><TD>PIUM_PCCC</TD><TD>4</TD><TD>PIUM_PCCD</TD><TD>MCO Review Outcome Accuracy</TD></TR><TR><TD>VV</TD><TD>PIUM_PCCC</TD><TD>7</TD><TD>PIUM_PCCD</TD><TD>Beneficiary Death</TD></TR><TR><TD>VV</TD><TD>PIUM_PCCC</TD><TD>2</TD><TD>PIUM_PCCD</TD><TD>Algorithm Limited Review</TD></TR><TR><TD>VV</TD><TD>PIUM_PCCC</TD><TD>5</TD><TD>PIUM_PCCD</TD><TD>State-Directed Recovery</TD></TR><TR><TD>VV</TD><TD>PIUM_PCCC</TD><TD>8</TD><TD>PIUM_PCCD</TD><TD>Provider Death</TD></TR><TR><TD>VV</TD><TD>PIUM_PCCC</TD><TD>3</TD><TD>PIUM_PCCD</TD><TD>DRA Attestation</TD></TR><TR><TD>VV</TD><TD>PIUM_PCCC</TD><TD>6</TD><TD>PIUM_PCCD</TD><TD>Excluded Entity</TD></TR><TR><TD>VV</TD><TD>PIUM_PCCC</TD><TD>9</TD><TD>PIUM_PCCD</TD><TD>Prepayment Review</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Please help me to do this by using Proc Transpose.</P><P>&nbsp;</P><P>Thanks,</P><P>Harish</P> Mon, 03 Jun 2019 06:10:11 GMT Harish2 2019-06-03T06:10:11Z DATA TRANSPOSE IN SAS https://communities.sas.com/t5/New-SAS-User/DATA-TRANSPOSE-IN-SAS/m-p/563181#M10865 <P>HI team,</P><P>&nbsp;</P><P>I have the table called Customer and data looks like this.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Customer</TD></TR><TR><TD>_TEMA001</TD><TD>PIUM_PCCC</TD><TD>PIUM_PCCD</TD></TR><TR><TD>VV</TD><TD>1</TD><TD>Provider Comprehensive SURS Review</TD></TR><TR><TD>VV</TD><TD>4</TD><TD>MCO Review Outcome Accuracy</TD></TR><TR><TD>VV</TD><TD>7</TD><TD>Beneficiary Death</TD></TR><TR><TD>VV</TD><TD>2</TD><TD>Algorithm Limited Review</TD></TR><TR><TD>VV</TD><TD>5</TD><TD>State-Directed Recovery</TD></TR><TR><TD>VV</TD><TD>8</TD><TD>Provider Death</TD></TR><TR><TD>VV</TD><TD>3</TD><TD>DRA Attestation</TD></TR><TR><TD>VV</TD><TD>6</TD><TD>Excluded Entity</TD></TR><TR><TD>VV</TD><TD>9</TD><TD>Prepayment Review</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I need the output of this customer</P><P>&nbsp;</P><P>table into below format by using Proc Transpose.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Output</TD></TR><TR><TD>VV</TD><TD>PIUM_PCCC</TD><TD>1</TD><TD>PIUM_PCCD</TD><TD>Provider Comprehensive SURS Review</TD></TR><TR><TD>VV</TD><TD>PIUM_PCCC</TD><TD>4</TD><TD>PIUM_PCCD</TD><TD>MCO Review Outcome Accuracy</TD></TR><TR><TD>VV</TD><TD>PIUM_PCCC</TD><TD>7</TD><TD>PIUM_PCCD</TD><TD>Beneficiary Death</TD></TR><TR><TD>VV</TD><TD>PIUM_PCCC</TD><TD>2</TD><TD>PIUM_PCCD</TD><TD>Algorithm Limited Review</TD></TR><TR><TD>VV</TD><TD>PIUM_PCCC</TD><TD>5</TD><TD>PIUM_PCCD</TD><TD>State-Directed Recovery</TD></TR><TR><TD>VV</TD><TD>PIUM_PCCC</TD><TD>8</TD><TD>PIUM_PCCD</TD><TD>Provider Death</TD></TR><TR><TD>VV</TD><TD>PIUM_PCCC</TD><TD>3</TD><TD>PIUM_PCCD</TD><TD>DRA Attestation</TD></TR><TR><TD>VV</TD><TD>PIUM_PCCC</TD><TD>6</TD><TD>PIUM_PCCD</TD><TD>Excluded Entity</TD></TR><TR><TD>VV</TD><TD>PIUM_PCCC</TD><TD>9</TD><TD>PIUM_PCCD</TD><TD>Prepayment Review</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Please help me to do this by using Proc Transpose.</P><P>&nbsp;</P><P>Thanks,</P><P>Harish</P> Mon, 03 Jun 2019 06:10:11 GMT https://communities.sas.com/t5/New-SAS-User/DATA-TRANSPOSE-IN-SAS/m-p/563181#M10865 Harish2 2019-06-03T06:10:11Z Re: DATA TRANSPOSE IN SAS https://communities.sas.com/t5/New-SAS-User/DATA-TRANSPOSE-IN-SAS/m-p/563187#M10866 <P>You do not transpose anything, you just add two columns with fixed content. That needs only a data step.</P> Mon, 03 Jun 2019 06:30:22 GMT https://communities.sas.com/t5/New-SAS-User/DATA-TRANSPOSE-IN-SAS/m-p/563187#M10866 Kurt_Bremser 2019-06-03T06:30:22Z