Data Spliting

[KalaBhairava]

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.

[PeterClemmensen]

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 🙂

[KalaBhairava]

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 

[Kurt_Bremser]

---

@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.

[Reeza]

---

@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...