topic Re: In output i want integers as appear in data and decimal numbers with two decimal places in SAS Programming

In output i want integers as appear in data and decimal numbers with two decimal places

Minku — Thu, 02 Apr 2020 11:03:57 GMT

I have data like below

data a;

input x;

cards;

1234

0.005

0.634

run;

I want output as below

1234

0.00

0.63

Can anyone please suggest me

Re: In output i want integers as appear in data and decimal numbers with two decimal places

Kurt_Bremser — Thu, 02 Apr 2020 11:11:43 GMT

Define "output".

If you want this kind of behavior in a dataset, you need to create a custom format with a function.

If you want it in a report, consider proc report and a computed column.

Re: In output i want integers as appear in data and decimal numbers with two decimal places

Minku — Thu, 02 Apr 2020 11:15:48 GMT

I want in data set, can you please write how to write custom format with function

Thanks for your reply

Re: In output i want integers as appear in data and decimal numbers with two decimal places

Kurt_Bremser — Thu, 02 Apr 2020 11:30:50 GMT

See here:

proc fcmp outlib=work.functions.smd;
function myfunc (arg) $;
  if int(arg) = arg
  then out = left(put(arg,best18.));
  else out = left(put(arg,18.2));
  return(out);
endsub;
run;

options cmplib=work.functions;

proc format;
value myfmt (default=18) other=[myfunc()];
run;

data a;
input x;
format x myfmt.;
y = put(x,myfmt.);
cards;
1234
54
0.005
0.634
;

Relevant parts of the documentation:

FUNCTION Statement in PROC FCMP

PROC FORMAT (Example 20)

Re: In output i want integers as appear in data and decimal numbers with two decimal places

Minku — Thu, 02 Apr 2020 11:42:16 GMT

Thanks 🙂