topic Re: question about recoding a variable in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/question-about-recoding-a-variable/m-p/143601#M38204 <HTML><HEAD></HEAD><BODY><P>Thank you <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P></BODY></HTML> Thu, 29 Jan 2015 04:22:56 GMT angi_916 2015-01-29T04:22:56Z question about recoding a variable https://communities.sas.com/t5/SAS-Procedures/question-about-recoding-a-variable/m-p/143599#M38202 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I’d appreciate any suggestions on recoding a variable in the following manner:</P><P></P><P>Have</P><TABLE align="left" border="1" cellpadding="0" cellspacing="0" style="border: none; margin-left: 6.75pt; margin-right: 6.75pt; padding: 0 5.4pt 0 5.4pt;"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="150"><P><STRONG>Var_A</STRONG></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="150"><P>00 Education ABC</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="150"><P>00 Education XYZ</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="150"><P>00 Education ABC</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="150"><P>00 Education MNO</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="150"><P>00 Education IJK</P></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P>Want</P><TABLE align="left" border="1" cellpadding="0" cellspacing="0" style="border: none; margin-left: 6.75pt; margin-right: 6.75pt; padding: 0 5.4pt 0 5.4pt;"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="150"><P><STRONG>Var_A</STRONG></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="150"><P>ABC</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="150"><P>XYZ</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="150"><P>ABC</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="150"><P>MNO</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="150"><P>IJK</P></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P>Thank you,</P></BODY></HTML> Thu, 29 Jan 2015 04:14:01 GMT https://communities.sas.com/t5/SAS-Procedures/question-about-recoding-a-variable/m-p/143599#M38202 angi_916 2015-01-29T04:14:01Z Re: question about recoding a variable https://communities.sas.com/t5/SAS-Procedures/question-about-recoding-a-variable/m-p/143600#M38203 <HTML><HEAD></HEAD><BODY><P>Look at the scan function</P><P><A href="http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000214639.htm" title="http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000214639.htm">SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition</A></P><P>var_a=scan(var_a, 3);&nbsp; </P></BODY></HTML> Thu, 29 Jan 2015 04:18:51 GMT https://communities.sas.com/t5/SAS-Procedures/question-about-recoding-a-variable/m-p/143600#M38203 Reeza 2015-01-29T04:18:51Z Re: question about recoding a variable https://communities.sas.com/t5/SAS-Procedures/question-about-recoding-a-variable/m-p/143601#M38204 <HTML><HEAD></HEAD><BODY><P>Thank you <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P></BODY></HTML> Thu, 29 Jan 2015 04:22:56 GMT https://communities.sas.com/t5/SAS-Procedures/question-about-recoding-a-variable/m-p/143601#M38204 angi_916 2015-01-29T04:22:56Z