topic Is there a function/format to convert word number to numeric number? in SAS Procedures

Is there a function/format to convert word number to numeric number?

allaboutsas — Thu, 18 Dec 2014 22:30:18 GMT

Like from one to 1, two to 2, etc.

Re: Is there a function/format to convert word number to numeric number?

ballardw — Thu, 18 Dec 2014 22:46:21 GMT

Not as provided as of 9.3. Do have any idea of the range of values represented? It might be possible to create a limited informat or hash look up table if your input data is clean enough.

Re: Is there a function/format to convert word number to numeric number?

art297 — Thu, 18 Dec 2014 22:47:06 GMT

Not that I'm aware of, but you can always roll your own format. If they are just integers you could expand the following to cover the range you need:

data seed;

length start $100;

retain fmtname 'wordnum' type 'c';

do label=1 to 100;

start=put(label,words100.);

output;

end;

hlo='O';

label='***ERROR***';

output;

run;

proc format library=work cntlin=seed;

run;

data have;

input wordnums $100.;

cards;

five

six

seven

eight

nine

ten

eleven

twelve

thirteen

fourteen

fifteen

sixteen

seventeen

eighteen

nineteen

twenty

twenty-one

twenty-two

twenty-three

twenty-four

twenty-five

twenty-six

twenty-seven

twenty-eight

twenty-nine

;

data want;

set have;

numbers=put(wordnums,$wordnum.);

run;