topic Re: Proc report in SAS Procedures

Proc report

sasuser123123 — Wed, 06 Nov 2019 07:07:24 GMT

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

Re: Proc report

sasuser123123 — Wed, 06 Nov 2019 07:08:41 GMT

Sorry for the mistake
Q1,Q3 133333333.185

Re: Proc report

andreas_lds — Wed, 06 Nov 2019 07:11:33 GMT

Please post code and data in usable form.

Re: Proc report

sasuser123123 — Wed, 06 Nov 2019 07:19:07 GMT

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;

Re: Proc report

LinusH — Wed, 06 Nov 2019 09:58:37 GMT

And data...

Re: Proc report

sasuser123123 — Wed, 06 Nov 2019 11:48:45 GMT

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

Re: Proc report

PaigeMiller — Wed, 06 Nov 2019 12:01:42 GMT

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-data-AKA-generate/ta-p/258712

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