BookmarkSubscribeRSS Feed
sasuser123123
Quartz | Level 8
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


6 REPLIES 6
sasuser123123
Quartz | Level 8
Sorry for the mistake
Q1,Q3 133333333.185
andreas_lds
Jade | Level 19

Please post code and data in usable form.

sasuser123123
Quartz | Level 8
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
Tourmaline | Level 20

And data...

Data never sleeps
sasuser123123
Quartz | Level 8
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
Diamond | Level 26

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.

--
Paige Miller

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

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
  • 6 replies
  • 894 views
  • 0 likes
  • 4 in conversation