SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
mano
Calcite | Level 5

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Jagadishkatam
Amethyst | Level 16

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

2 REPLIES 2
Jagadishkatam
Amethyst | Level 16

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
mano
Calcite | Level 5

Thanks Jagadish.

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

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