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
PROC Star

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 2024

Innovate_SAS_Blue.png

Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

Register now!

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.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 6 replies
  • 420 views
  • 0 likes
  • 4 in conversation