topic alligning values in a column in proc report in SAS Programming

alligning values in a column in proc report

mano — Fri, 15 Mar 2013 03:47:27 GMT

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.

Re: alligning values in a column in proc report

Jagadishkatam — Fri, 15 Mar 2013 04:11:24 GMT

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

Re: alligning values in a column in proc report

mano — Sat, 16 Mar 2013 02:13:24 GMT

Thanks Jagadish.