Solved
Contributor
Posts: 29

# alligning values in a column in proc report

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.

Accepted Solutions
Solution
‎03-15-2013 12:11 AM
Posts: 1,147

## Re: alligning values in a column in proc report

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,

Thanks,
Jag

All Replies
Solution
‎03-15-2013 12:11 AM
Posts: 1,147

## Re: alligning values in a column in proc report

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,

Thanks,
Jag
Contributor
Posts: 29