topic Character variables to columns in New SAS User https://communities.sas.com/t5/New-SAS-User/Character-variables-to-columns/m-p/531977#M5951 <P>Hi everyone,&nbsp;</P><P>&nbsp;</P><P>I have an excel file that has data that looks like this:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Services&nbsp;</TD></TR><TR><TD>BC-1</TD></TR><TR><TD>0</TD></TR><TR><TD>0</TD></TR><TR><TD>BC-1<BR />MI-1</TD></TR><TR><TD>0</TD></TR><TR><TD>BC-1<BR />PC-1<BR />MI-1</TD></TR><TR><TD>Assess B-1<BR />BC-1<BR />HR-1<BR />MHA-1</TD></TR><TR><TD>CC-1</TD></TR><TR><TD>Assess B-1<BR />BC-1</TD></TR><TR><TD>HR-4</TD></TR><TR><TD>BN-1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>What I would like to do is transpose each category into&nbsp; a column from&nbsp; each cell. So what I would like is:</P><P>&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>BC</TD><TD>MI</TD><TD>PC</TD><TD>AssessB</TD><TD>HR</TD><TD>BN</TD><TD>MHA</TD><TD>CC</TD></TR><TR><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>1</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>1</TD><TD>1</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>1</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD></TR><TR><TD>1</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>4</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Any help would be greatly appreciated thank you!&nbsp;</P> Fri, 01 Feb 2019 13:47:41 GMT hwangnyc 2019-02-01T13:47:41Z Character variables to columns https://communities.sas.com/t5/New-SAS-User/Character-variables-to-columns/m-p/531977#M5951 <P>Hi everyone,&nbsp;</P><P>&nbsp;</P><P>I have an excel file that has data that looks like this:</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Services&nbsp;</TD></TR><TR><TD>BC-1</TD></TR><TR><TD>0</TD></TR><TR><TD>0</TD></TR><TR><TD>BC-1<BR />MI-1</TD></TR><TR><TD>0</TD></TR><TR><TD>BC-1<BR />PC-1<BR />MI-1</TD></TR><TR><TD>Assess B-1<BR />BC-1<BR />HR-1<BR />MHA-1</TD></TR><TR><TD>CC-1</TD></TR><TR><TD>Assess B-1<BR />BC-1</TD></TR><TR><TD>HR-4</TD></TR><TR><TD>BN-1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>What I would like to do is transpose each category into&nbsp; a column from&nbsp; each cell. So what I would like is:</P><P>&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>BC</TD><TD>MI</TD><TD>PC</TD><TD>AssessB</TD><TD>HR</TD><TD>BN</TD><TD>MHA</TD><TD>CC</TD></TR><TR><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>1</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>1</TD><TD>1</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>1</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>1</TD><TD>0</TD><TD>1</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>1</TD></TR><TR><TD>1</TD><TD>0</TD><TD>0</TD><TD>1</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR><TR><TD>0</TD><TD>0</TD><TD>0</TD><TD>0</TD><TD>4</TD><TD>0</TD><TD>0</TD><TD>0</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Any help would be greatly appreciated thank you!&nbsp;</P> Fri, 01 Feb 2019 13:47:41 GMT https://communities.sas.com/t5/New-SAS-User/Character-variables-to-columns/m-p/531977#M5951 hwangnyc 2019-02-01T13:47:41Z Re: Character variables to columns https://communities.sas.com/t5/New-SAS-User/Character-variables-to-columns/m-p/532353#M6016 <P><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/81036">@hwangnyc</a>&nbsp;</P> <P>Looking at your Have and Want data I can't figure out the transpose logic. Can you please elaborate?</P> Sun, 03 Feb 2019 06:30:15 GMT https://communities.sas.com/t5/New-SAS-User/Character-variables-to-columns/m-p/532353#M6016 Patrick 2019-02-03T06:30:15Z