https://communities.sas.com/t5/SAS-Procedures/Rename-observation/m-p/476260#M71207 <P>Hi guys. I have upload some sample data which has 3 variables i.e Date,&nbsp;NAME OF FORMER VARIABLE, and COL1. I would like eliminate "_P_" on every observation under the variable "<SPAN>NAME OF FORMER VARIABLE". How can i get this done with lots of observations. Looking forward to your positive responses.</SPAN></P> <P>&nbsp;</P> <TABLE width="326"> <TBODY> <TR> <TD width="75">Date</TD> <TD width="187">NAME OF FORMER VARIABLE</TD> <TD width="64">COL1</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_VIC_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_VNM_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_VCB_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_GAS_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_BID_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_HPG_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_MSN_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_CTG_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_BVH_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_MBB_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_CTD_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_DXG_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_DIG_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_FPT_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_GMD_P_</TD> <TD>50000</TD> </TR> </TBODY> </TABLE> Sun, 08 Jul 2018 04:39:54 GMT ivanpersie 2018-07-08T04:39:54Z https://communities.sas.com/t5/SAS-Procedures/Rename-observation/m-p/476260#M71207 <P>Hi guys. I have upload some sample data which has 3 variables i.e Date,&nbsp;NAME OF FORMER VARIABLE, and COL1. I would like eliminate "_P_" on every observation under the variable "<SPAN>NAME OF FORMER VARIABLE". How can i get this done with lots of observations. Looking forward to your positive responses.</SPAN></P> <P>&nbsp;</P> <TABLE width="326"> <TBODY> <TR> <TD width="75">Date</TD> <TD width="187">NAME OF FORMER VARIABLE</TD> <TD width="64">COL1</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_VIC_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_VNM_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_VCB_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_GAS_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_BID_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_HPG_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_MSN_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_CTG_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_BVH_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_MBB_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_CTD_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_DXG_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_DIG_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_FPT_P_</TD> <TD>50000</TD> </TR> <TR> <TD>01/01/2007</TD> <TD>VT_GMD_P_</TD> <TD>50000</TD> </TR> </TBODY> </TABLE> Sun, 08 Jul 2018 04:39:54 GMT https://communities.sas.com/t5/SAS-Procedures/Rename-observation/m-p/476260#M71207 ivanpersie 2018-07-08T04:39:54Z https://communities.sas.com/t5/SAS-Procedures/Rename-observation/m-p/476262#M71208 <P>try</P><P>&nbsp;</P><PRE><CODE class=" language-sas">data want; set have; new_var=substr(_name_,1,length(strip(_name_))-3); drop _name_; run;</CODE></PRE> Sun, 08 Jul 2018 04:58:41 GMT https://communities.sas.com/t5/SAS-Procedures/Rename-observation/m-p/476262#M71208 novinosrin 2018-07-08T04:58:41Z https://communities.sas.com/t5/SAS-Procedures/Rename-observation/m-p/476264#M71209 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/138205">@novinosrin</a>&nbsp;wrote:<BR /> <P>try</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data want; set have; new_var=substr(_name_,1,length(strip(_name_))-3); drop _name_; run;</CODE></PRE> <HR /></BLOCKQUOTE> <P>Thanks a bunch. It worked well.</P> Sun, 08 Jul 2018 05:05:19 GMT https://communities.sas.com/t5/SAS-Procedures/Rename-observation/m-p/476264#M71209 ivanpersie 2018-07-08T05:05:19Z