topic Re: data set creations in SAS Programming

data set creations

Brijesh4sas — Wed, 04 May 2022 05:34:00 GMT

Data clinical;
input center$ trail$ sub adsub;
cards;
appolo phase1 67 12
nims phase1 78 14
care phase1 34 10
appolo phase2 267 22
nims phase2 178 14
care phase2 234 40
;
run;
How to put all appolo value in DSN1,

put all nims value in DSN2,

put all care value in DSN3 by automation

Data set creation

Brijesh4sas — Wed, 04 May 2022 05:30:28 GMT

Hello,

How to create multiple DSN according to different variables.

Re: Data set creation

LinusH — Wed, 04 May 2022 07:15:10 GMT

Please try to be more specific about your requirement.

Re: data set creations

LinusH — Wed, 04 May 2022 07:16:33 GMT

Combine IF-statements with explicit OUTPUT statements.

Re: Data set creation

andreas_lds — Wed, 04 May 2022 07:30:50 GMT

I have merged both posts with the same title. If both are about different problems, please use more meaningful titles next time.

Re: data set creations

BrahmanandaRao — Wed, 04 May 2022 08:37:48 GMT

Data clinical;
input center$ trail$ sub adsub;
cards;
appolo phase1 67 12
nims phase1 78 14
care phase1 34 10
appolo phase2 267 22
nims phase2 178 14
care phase2 234 40
;
run;

data appolo nims care;
set clinical;
if center ='appolo' then output appolo ;
if center ='nims' then output nims ;
if center ='care' then output care ;
run;

Re: data set creations

Kurt_Bremser — Wed, 04 May 2022 13:18:15 GMT

Splitting datasets is VERY rarely needed. I guess you want to do this for reporting or data export, and for this there are better methods. Please give us the "big picture".

Re: data set creations

Kurt_Bremser — Wed, 04 May 2022 13:20:11 GMT

@BrahmanandaRao wrote:
Data clinical;
input center$ trail$ sub adsub;
cards;
appolo phase1 67 12
nims phase1 78 14
care phase1 34 10
appolo phase2 267 22
nims phase2 178 14
care phase2 234 40
;
run;

data appolo nims care;
set clinical;
if center ='appolo' then output appolo ;
if center ='nims' then output nims ;
if center ='care' then output care ;
run;

Consider using a data step SELECT Statement instead of multiple IFs.

Re: data set creations

Brijesh4sas — Sat, 07 May 2022 05:50:54 GMT

Thank you but i need to automate it.

Re: data set creations

Kurt_Bremser — Sat, 07 May 2022 06:59:44 GMT

Please show us the "big picture". This looks like a XY Problem

Re: data set creations

PaigeMiller — Sat, 07 May 2022 11:14:23 GMT

@Brijesh4sas wrote:
Thank you but i need to automate it.

Thank you, but we need to UNDERSTAND what you are trying to do. For us to understand, you have to explain, which usually means you have to be generous with information, and provide additional information that we ask for, rather than what you have done so far which is to provide so few words that we don't understand. Please start with the answer to @Kurt_Bremser 's question and explain what you are trying to do.

We're trying to help you, but you have to help us too.

Re: data set creations

Brijesh4sas — Sun, 08 May 2022 12:49:19 GMT

data appolo nims care;
set clinical;
if center ='appolo' then output appolo ;
if center ='nims' then output nims ;
if center ='care' then output care ;
run;

I want to automate this

Re: data set creations

Kurt_Bremser — Sun, 08 May 2022 16:00:45 GMT

@Brijesh4sas wrote:
data appolo nims care;
set clinical;
if center ='appolo' then output appolo ;
if center ='nims' then output nims ;
if center ='care' then output care ;
run;

I want to automate this

This post is perfectly useless, as does not provide any additional information.

What for do you think that you need the split datasets?

Re: data set creations

Brijesh4sas — Sun, 08 May 2022 16:57:14 GMT

Data clinical;
input center$ trail$ sub adsub;
cards;
appolo phase1 67 12
nims phase1 78 14
care phase1 34 10
appolo phase2 267 22
nims phase2 178 14
care phase2 234 40
;
run;

i want to create DSN based on var=center

Re: data set creations

Brijesh4sas — Sun, 08 May 2022 16:59:54 GMT

Re: data set creations

Kurt_Bremser — Sun, 08 May 2022 17:07:00 GMT

WHAT FOR???

As already stated, splitting datasets is VERY rarely needed, so what do you intend to do with the resulting datasets?

Re: data set creations

Brijesh4sas — Mon, 09 May 2022 03:34:42 GMT

yes, resulting datasets

Re: data set creations

Kurt_Bremser — Mon, 09 May 2022 05:10:51 GMT

I am obviously talking to a brick wall.