topic Re: delete blank in ODS and Base Reporting

delete blank

oujiang — Wed, 30 Oct 2013 03:07:02 GMT

hi!

i have a word like this "At 63.6% , the labour-force participation rate is at its lowest level",

but I want to get the result like this "At 63.6%, the labour-force participation rate is at its lowest level",

What should I do?

JerryLeBreton — Wed, 30 Oct 2013 03:19:38 GMT

Use the COMPBL function.

oujiang — Wed, 30 Oct 2013 03:29:19 GMT

not work,have a error !

ERROR: The function COMPBL referenced by the %SYSFUNC or %QSYSFUNC macro function has too many arguments.

Will not be the "%" problem?

JerryLeBreton — Wed, 30 Oct 2013 03:29:27 GMT

Ah yes, then to get rid of the space between % and ,

tranwrd(compbl(string), " ,", ",")

JerryLeBreton — Wed, 30 Oct 2013 03:43:56 GMT

If your are doing this in a macro, you will need something like this:

%let want = %sysfunc(tranwrd(%qsysfunc(compbl(%quote(&have))), %str(% ,), %str(%,)));

Astounding — Wed, 30 Oct 2013 13:27:10 GMT

It would be easier to correct the problem earlier in the process, rather than after the string has been created.

Your code has created a macro variable that contains leading and trailing blanks, such as 63.6%

Get rid of the leading and trailing blanks before plugging that into the longer string. One easy way:

%let macrovar = &macrovar;

Then plug it in:

%let string = At &macrovar, the labour-force participation rate is at its lowest level;

Good luck.