topic Macro function to mask decimal place in SAS Programming

Macro function to mask decimal place

suncawy — Tue, 29 Jan 2013 02:10:39 GMT

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 — Tue, 29 Jan 2013 03:11:25 GMT

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

%sysfunc(compress(&icd_code,.))

suncawy — Tue, 29 Jan 2013 04:38:48 GMT

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