Proc report

[sasuser123123]

Hello!!
I've data of
Name trt
No.of doses
N 5
Mean 6
Sd 0
Median 6
Q1,Q3 6,6
Min,max 6,6

Cumulative sum
N 5
Mean 500
Sd 200
Median 860
Q1,Q3 800,1110
Min,max 150,400

Average

N 5
Mean 155
Sd 33
Median 143.3333
Q1,Q3 133.3333,185
Min,max 118.33333,195

So I'm create a report for this data
In report I got

Q1,Q3 143.333333
Min,max 118333333.195
In the average value.

The Q1 Q3 values are combined without comma

I don't know why it's happening..

Could you please solve my query.

Thank you

[sasuser123123]

Sorry for the mistake
Q1,Q3 133333333.185

[andreas_lds]

Please post code and data in usable form.

[sasuser123123]

Ods listing close;
Ods rtf file="output path\out.rtf";
Proc report data=final split='$';
Column name trt;
Define name/dislpaly " ";
Define TRT/display "[Trt]" '$' "[&n]" center;
Run;
Ods rtf close;
Ods listing;

[LinusH]

And data...

[sasuser123123]

The dataset which I have

Name drugX

No.of doses
N 5
Mean 6
Sd 0
Median 6
Q1,Q3 6,6
Min,max 6,6
Cumulative sum
N 5
Mean 500
Sd 200
Median 860
Q1,Q3 800,1110
Min,max 150,400
Average
N 5
Mean 155
Sd 33
Median 143.3333
Q1,Q3 133.3333,185
Min,max 118.33333,195

[PaigeMiller]

I think the data in this form is not usable for us. We want the SAS data set (not some textified version that you are showing) by following these instructions: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

That way, we can actually use the data in SAS, and produce code that would work with your exact data.