topic Re: converting all character variables to numeric except for one in New SAS User

converting all character variables to numeric except for one

jffeudo86 — Wed, 21 Aug 2019 18:54:58 GMT

Hello,

I have 10 variables in my dataset that are character. 9 of them should be numeric. Is there a solution using array that would convert the 9 to numeric? like:

array xx _character_;

do over xx;

<if variable is not what I want, leave it alone, else convert to numeric>;

end;

Thanks!

Re: converting all character variables to numeric except for one

Reeza — Wed, 21 Aug 2019 19:07:35 GMT

Sure, use VNAME() to get the variable name. But you only have 10 variables, it's just as easy to list them, if the variable you want to exclude is first or last it's much easier as well.

Note that when doing type conversion in SAS you need to store them in a new variable so you'll have to create the new variable names anyways. In that case you may as well just list them.

Or it's usually easier to go back and fix your import, if that was the issue, and read in the data correctly the first time.

data want;
set have;

array old(*) $ _character_;
array new(*) $ new_varname1 new_varname2 ..... new_varname10;

do i=1 to dim(old);
if vname(old(i)) ne 'VariableName2Exclude' then 
new(i) = input(old(i), 8.);
end;

run;

Re: converting all character variables to numeric except for one

jffeudo86 — Wed, 21 Aug 2019 19:09:10 GMT

I learned a new thing today, vname. Thank you!

Re: converting all character variables to numeric except for one

ballardw — Wed, 21 Aug 2019 20:51:11 GMT

If you wanted the variables to be numeric why were they character to begin with?