topic How to make it to with two demicals? in SAS Programming

How to make it to with two demicals?

rajeshalwayswel — Fri, 22 Dec 2017 11:44:13 GMT

data have;
input a$ 10.;
cards;
1.2346565
1.244
1.562546
run;

Re: How to make it to with two demicals?

RW9 — Fri, 22 Dec 2017 11:51:28 GMT

Pro tip - start by reading how to post a question. Explain what you want, using the body of the post to explain this. A post topic saying make it work is not in the least bit polite or helpful.

Taking a rough guess, I would say you want a numeric which is rounded to 2 decimal places from that text, if so:

data want;
  set have;
  want=round(input(a,best.),0.01);
run;

Re: How to make it to with two demicals?

PeterClemmensen — Fri, 22 Dec 2017 11:55:27 GMT

Do you want to keep the varaible type character? If so

data have;
input a$ 10.;
cards;
1.2346565
1.244
1.562546
run;

data want_round;
	set have;
	round_a=strip(put(round(a, .01), best6.2));
run;