I have a dataset which has a variable in which data is for example tmmd_fdf_er and i want to remove_fdf_er from the data.
I dont know whether substr can be used in this case
You can do this in various methods. One way is:
tranwrd(string,"_fdf_er","");
the string needs to be the same (upper/lower and spacing).
Or substr:
substr(string,1,index(string,"_")-1);
Or various other methods (perl RE comes to mind, plus replace etc.)
You can do this in various methods. One way is:
tranwrd(string,"_fdf_er","");
the string needs to be the same (upper/lower and spacing).
Or substr:
substr(string,1,index(string,"_")-1);
Or various other methods (perl RE comes to mind, plus replace etc.)
data x; a= 'tmmd_fdf_er'; b=substr(a,1,length(a)-7); c=prxchange('s/.{7}$//',-1,a); run;
Xia Keshan
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.