wildcards to remove zeros in my numeric variables

Hank — Sun, 09 Feb 2014 12:59:38 GMT

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

Re: wildcards to remove zeros in my numeric variables

data_null__ — Sun, 09 Feb 2014 13:14:46 GMT

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.

topic wildcards to remove zeros in my numeric variables in SAS Data Management

wildcards to remove zeros in my numeric variables

Re: wildcards to remove zeros in my numeric variables