topic Re: Data Spliting in SAS Programming

Data Spliting

KalaBhairava — Mon, 18 Nov 2019 06:51:34 GMT

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.

Re: Data Spliting

PeterClemmensen — Mon, 18 Nov 2019 07:22:56 GMT

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 🙂

Re: Data Spliting

KalaBhairava — Mon, 18 Nov 2019 07:56:11 GMT

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

Re: Data Spliting

Kurt_Bremser — Mon, 18 Nov 2019 08:09:21 GMT

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

Re: Data Spliting

Reeza — Mon, 18 Nov 2019 17:02:35 GMT

@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-data-AKA-generate/ta-p/258712