Converting numeric data stored as character to numeric in SAS

Question

I'm trying to pull data stored as $24. I want to convert it from character to numeric. The input(variable-name,comma24.) function is not working for me. A sample of the data is given below.

5.35 5.78 413,000 3,280,000 5.97 6.72 5 6.53 6 4.59 4.25 5 6.38 6.41 4.1 6.56 5.45 6.07 4.28 5.54 5.87 3.88 5.53 5.65 6.47 207,000 4,935,000 4,400,000 6,765,000 2,856,000 53,690,000

Have you tried comma24.2?

John Chrysostom
– John Chrysostom

2014-05-13 19:05:44 +00:00
Commented May 13, 2014 at 19:05 — John Chrysostom
– John Chrysostom, Commented May 13, 2014 at 19:05

Aniko · Accepted Answer · 2014-05-13 19:11:12Z

1

You don't show your code, but for some reason I could get it work when the reading and conversion were in different data steps, but not when it was the same data step.

The following works just fine:

DATA one;
  INPUT y: $24. @@;
DATALINES;
5.35 5.78 413,000 3,280,000 5.97
RUN;

DATA one;
  SET one;
  z = INPUT(y, comma24.);
RUN;

However if I put the calculation of z in the first data step, I was getting missing values without any error message. I have no explanation for this behavior, but hopefully the workaround will work for you as well.

answered May 13, 2014 at 19:11

Aniko

19k4 gold badges50 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nickolay Over a year ago

FWIW, putting conversion in the first data step (after the first input statement) works fine for me; SAS 9.2M3 / Windows.

Collectives™ on Stack Overflow

Converting numeric data stored as character to numeric in SAS

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related