DATA Step, Macro, Functions and more

alligning values in a column in proc report

Accepted Solution Solved
Reply
Contributor
Posts: 28
Accepted Solution

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
Trusted Advisor
Posts: 1,128

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,

Jagadish

Thanks,
Jag

View solution in original post


All Replies
Solution
‎03-15-2013 12:11 AM
Trusted Advisor
Posts: 1,128

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,

Jagadish

Thanks,
Jag
Contributor
Posts: 28

Re: alligning values in a column in proc report

Thanks Jagadish.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 164 views
  • 0 likes
  • 2 in conversation