Rename observation

[ivanpersie]

Hi guys. I have upload some sample data which has 3 variables i.e Date, NAME OF FORMER VARIABLE, and COL1. I would like eliminate "_P_" on every observation under the variable "NAME OF FORMER VARIABLE". How can i get this done with lots of observations. Looking forward to your positive responses.

Date	NAME OF FORMER VARIABLE	COL1
01/01/2007	VT_VIC_P_	50000
01/01/2007	VT_VNM_P_	50000
01/01/2007	VT_VCB_P_	50000
01/01/2007	VT_GAS_P_	50000
01/01/2007	VT_BID_P_	50000
01/01/2007	VT_HPG_P_	50000
01/01/2007	VT_MSN_P_	50000
01/01/2007	VT_CTG_P_	50000
01/01/2007	VT_BVH_P_	50000
01/01/2007	VT_MBB_P_	50000
01/01/2007	VT_CTD_P_	50000
01/01/2007	VT_DXG_P_	50000
01/01/2007	VT_DIG_P_	50000
01/01/2007	VT_FPT_P_	50000
01/01/2007	VT_GMD_P_	50000

[novinosrin · Accepted solution]

try

data want;
set have;
new_var=substr(_name_,1,length(strip(_name_))-3);
drop _name_;
run;

[ivanpersie]

---

@novinosrin wrote:

try

data want;
set have;
new_var=substr(_name_,1,length(strip(_name_))-3);
drop _name_;
run;

---

Thanks a bunch. It worked well.