Hi All,
I have data in data set in below format
Baseline:Value
Number
Mean (SD)
Median
Q1 : Q3
Min : Max
Week 12 :Change from baseline
Number
Mean (SD)
LS Mean (SE) a
LS Mean Diff vs. matching placebo (95% CI) a
P-value vs. matching placebo a
But I want :
Baseline:
Value
Number
Mean (SD)
Median
Q1 : Q3
Min : M
Week 12 :
Change from baseline
Number
Mean (SD)
LS Mean (SE) a
LS Mean Diff vs. matching placebo (95% CI) a
P-value vs. matching placebo a
Is it possible to split this in output or with in the data set.
Can you post your data in a usable form? I still don't know what your data looks like. Makes it easier to help you 🙂
Sorry sir i can't post data, in one column i want split data, you can imagine as XYZ.. ,, is there any way to do like that,
if an option in proc report also not a problem
@KalaBhairava wrote:
Sorry sir i can't post data, in one column i want split data, you can imagine as XYZ.. ,, is there any way to do like that,
if an option in proc report also not a problem
If you can't write a data step with datalines, then you should learn that NOW. If you don't want to post sensitive data, make up some fake data to illustrate your issue. Help us to help you.
Especially when you're having a hard time posting intelligible text in a foreign language, using the SAS language as the common idiom is the way to go.
@KalaBhairava wrote:
Sorry sir i can't post data, in one column i want split data, you can imagine as XYZ.. ,, is there any way to do like that,
if an option in proc report also not a problem
Make fake data if you cannot post real data. The point is to provide an example so that the solution will be actually something that works for you.
Here are instructions on how to provide sample data as a data step:
https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: