Macro function to mask decimal place

[suncawy]

Hello,

This will probably be easy for some one, but for the life of me I can't figure it out.

So, there is a macro variable like this:

   %let ICD_CODE =  V85.5

But I need to pass this macro variable as 'V855'  in query because this one

particular query uses that form.   All of the other queries uses the regular

macro variable value, V85.5.

So, how can I mask the decimal in the macro variable to pass to the query ?

[Tom · Accepted solution]

Use %SYSFUNC() to call the COMPRESS() function.

%sysfunc(compress(&icd_code,.))

[suncawy]

Thank You, Tom !  that was perfect.   I knew someone would have the answer.