topic changing a fraction character variable into a numeric decimal in SAS Programming

changing a fraction character variable into a numeric decimal

lmyers2 — Tue, 16 Mar 2021 23:58:02 GMT

Hello

I have data that looks like "70/40" but want to convert it from a character variable to a numeric fraction so I can get the decimal (1.75). I've tried the following within data steps but get errors to both saying that "fract" isn't recognized. Any ideas? Thanks for the help! I'm using SAS 9.4.

format PF_RATIO fract.;

PFRATIO=informat(PF_RATIO, FRACT6.);

Re: changing a fraction character variable into a numeric decimal

PGStats — Wed, 17 Mar 2021 00:48:59 GMT

Try

data test;
do pf_ratio = "70/40", "1.75";
    PFRATIO = input(scan(pf_ratio, 1, "/"), best.) / coalesce(input(scan(pf_ratio, 2, "/"), ?? best.), 1);
    output;
    end;
run;

Re: changing a fraction character variable into a numeric decimal

lmyers2 — Wed, 17 Mar 2021 02:14:20 GMT

Wow! Thanks! That worked perfectly!!

Re: changing a fraction character variable into a numeric decimal

ChrisNZ — Wed, 17 Mar 2021 02:37:53 GMT

Like this?

NB=resolve( '%sysevalf(' || PF_RATIO || ')' );

Input it to get a numeric.