topic Re: Extract Nondelemeted Values in SAS Programming

Extract Nondelemeted Values

JAR — Sat, 13 Aug 2011 10:51:39 GMT

How do I read individual numeric values of 31415?

This is how my dataset to look like:

Digits

Regards,

JAR

Extract Nondelemeted Values

art297 — Sat, 13 Aug 2011 12:40:07 GMT

I think your question may have gotten lost in its presentation. Are you asking how one would do the following:

data have;

input (x1-x5) (1.);

cards;

31415

;

run;

Re: Extract Nondelemeted Values

JAR — Sat, 13 Aug 2011 12:45:35 GMT

Say, I need value of pi. This one-variable dataset contains only digits of pi.

However, the raw data contains value of pi as a string 314159265.... How do I do it?

Regards,

JAR

Re: Extract Nondelemeted Values

art297 — Sat, 13 Aug 2011 13:02:10 GMT

There are a number of ways. One, for example, might be to use code like:

data have;

input x;

cards;

;

run;

data want;

set have end=last;

retain hold;

if _n_ eq 1 then hold=catt(x,'.');

else hold=catt(hold,x);

if last then do;

pi=input(hold,best12.);

output;

end;

run;

Of course, since there wasn't a decimal place in your example data, I had to force one in as part of the code. However, if all you wanted was the value of pi, the following would be a much easier way to go:

data easier;

pi=constant('pi');

run;

Re: Extract Nondelemeted Values

art297 — Sun, 14 Aug 2011 16:33:47 GMT

Just in case I have still misinterpreted what you asked, if you do have a one variable, one record dataset, with one string, how about?:

data have;

input x $9.;

cards;

314159265

;

run;

data want;

set have end=last;

pi=input(x,best12.8);

/* or if you want it as a macro variable

for use in other datasteps */

call symput('pi',pi);

run;

data test;

input x;

x_times_pi=x*&pi.;

/* or using the bulit-in constant */

x_times_pi_using_constant=x*constant('pi');

cards;

;

run;