topic Re: Percent format for comma values in SAS Programming

Percent format for comma values

Babloo — Thu, 23 Aug 2018 05:57:04 GMT

I ran the following code and end up with error as follows. Could you please help me with the format which translate comma values to percent? I don't wish to do any data manipulation here.

data foo; 
format y percent7.1; 
y=-0,01259870; 
run;
proc print data=foo; 
run;

Log:

26         data foo;
27         format y percent7.1;
28         y=-0,01259870;
               _
               388
               200
ERROR 388-185: Expecting an arithmetic operator.

ERROR 200-322: The symbol is not recognized and will be ignored.

Desired output:

1.3%

Re: Percent format for comma values

Jagadishkatam — Thu, 23 Aug 2018 05:59:55 GMT

you should use dot instead of comma
please try

data foo;
format y percent7.1;
y=-0.01259870;
run;
proc print data=foo;
run;

Re: Percent format for comma values

Babloo — Thu, 23 Aug 2018 06:23:44 GMT

No, I no need to convert comma to dot. I have values in my file like -0,01259870

Re: Percent format for comma values

Jagadishkatam — Thu, 23 Aug 2018 06:33:18 GMT

then please something as below

data foo;
format y percent7.1;
y=input(tranwrd('-0,01259870',',','.'),best.);
run;
proc print data=foo;
run;

Re: Percent format for comma values

Babloo — Thu, 23 Aug 2018 06:37:16 GMT

Is there anyway to deal this with only formats?

Re: Percent format for comma values

Jagadishkatam — Thu, 23 Aug 2018 06:59:11 GMT

As per my understanding functions would be a best approach, alternatively you could create a customized function by proc fcmp

Re: Percent format for comma values

Tom — Thu, 23 Aug 2018 07:02:07 GMT

You cannot write code using that non-standard method of using commas to replace decimal points.

But you can use the COMMAX informat to read strings that are written that way.

data test ;
  input @1 string $12. @1 number commax12. ;
  percent=number;
  format percent percent7.1 ;
  put (_all_) (=/);
cards;
-0,01259870
;

string=-0,01259870
number=-0.0125987
percent=( 1.3%)

Re: Percent format for comma values

ballardw — Fri, 24 Aug 2018 21:21:17 GMT

data test ;
  input number numx12. ;
  format number percent15.5 ;
cards;
-0,01259870
;
run;