topic Re: percent8.2 format in SAS Programming

percent8.2 format

Ronein — Thu, 30 Jan 2025 07:13:05 GMT

Hello

I have numeric values with format percent8.2

The negative values are displayed with ()

Example:

(11.60%)
1.41%

My question:

I want that negative values diaplay with minus and not ()

what is the way to do it?

Re: percent8.2 format

Amir — Thu, 30 Jan 2025 07:42:06 GMT

Hi,

You could try something like the below. It uses the PERCENTNw.d format (notice the extra "N" in PERCENTNw.d).

data have;
  format pc2 percentn8.2;
  input pc1;
  
  pc2 = pc1;
  
  datalines;
-0.116
0.0141
;

Thanks & kind regards,

Amir.

Edit: Typo.

Re: percent8.2 format

Ronein — Thu, 30 Jan 2025 19:07:44 GMT

Thanks.

so the difference is that I used percent8.2 and you used percentn8.2 ?

Re: percent8.2 format

Amir — Thu, 30 Jan 2025 20:41:13 GMT

Hi Ronein,

Yes, that appears to be the case. You can see more from the documentation by using the link I provided in my previous post; thanks for marking it as a solution.

Thanks & kind regards,

Amir.