alligning values in a column in proc report

[mano]

Hello,

In the final dataset , the values in col1 are as follows:-

col1                    col2

20 (98.0)              12 (12.8)

5 (9.0)                  10 (15.6)

17 (8.0)                 7 (9.7)

34 (88.3)               9 (24.0)

I just used some random number and percentages. I want these values to be displayed in the output as follows:-

col1                  col2

20 ( 98.0)          12 ( 12.8)

  5 (  9.0)           10 ( 15.6)

17 (  8.0)             7 (  9.7)

34 ( 88.3)            9 ( 24.0)

which options would work in the proc report to get the desired output.

Any help is deeply appreciated.

Thanks.

[Jagadishkatam · Accepted solution]

Hi

you get that output, but you need to use the put function while converting the numeric percentages to  character, as well numeric N value to character N value

While converting the percentages and n values to character follow the below steps especially the formats i used

data have;

    input n_ pct;

    pctc=put(pct,4.1);

    nc=put(n_,6.);

    new=nc||'('||pctc||')';

cards;

20 98.0           

5 9.0             

17 8.0            

34 88.3          

;

run;

Hope this helps

Thanks,

Jagadish

[mano]

Thanks Jagadish.