topic Re: string manipulation (deleting underscores) in SAS Procedures

string manipulation (deleting underscores)

SachinRuk — Tue, 26 Oct 2010 02:20:23 GMT

Hi all,

I have a macro variable say 'a' and usually has the string of type 'gross_combined_ratio'.

my question is how do you delete the underscore and replace it with a space. so that the string looks like 'gross combined ratio'

Thanks,
Sachin
p.s. sorry if this isnt the correct sub forum

Re: string manipulation (deleting underscores)

MHomes — Tue, 26 Oct 2010 03:29:04 GMT

Hi Sachin,

Is this what you were after?

%let a=gross_combined_ratio;
%let a=%sysfunc(translate(&a,%str( ),%str(_)));
%put _user_;

Cheers,
Michelle

Re: string manipulation (deleting underscores)

SachinRuk — Tue, 26 Oct 2010 05:46:34 GMT

yep. thanks heaps 😄

sachin