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

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

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
  • 1663 views
  • 0 likes
  • 4 in conversation