- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
Jag
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
Jag
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks Jagadish.