wildcards to remove zeros in my numeric variables

[Hank]

Hi,

I have a dataset with a set of numeric variables. The names are like "a_1" to "a_8" up to "f_1" to "f_6". So the names are a letter, underscore and a number  (not all the numeric variables are like this, but most of them).

I want to remove all the zeroes in the numeric variables with the structure like the one above. But I cant get any kind of wildcards to work. Does anyone have any idea?

So far, my attempts has been like:

data dataset1;

set dataset1;

if b%= 0 then b%= ' ' ;

run;

Best regards,

Hank

[data_null__ · Accepted solution]

You are using the wrong syntax.  You will need to create and ARRAY using a SAS Variable List then you can iterate through the elements in the array and use an IF statement to change the values as you see fit.