Hi,
I need to convert a character variable to numeric in order to run some descriptive statistics, but the values include decimals (dots/periods) that I want to save, and some special character (* < >) that I want to remove.
The values can look like this;
0.22
<0.09
25
2.4*
I want to remove all * < > and keep the dots.
The SAS-code, if helpful, could look like below;
input(compress(variablename,'*<>'),best.)
Regards,
/Annika