topic split my dataset into multiple datasets baased on three variables in New SAS User

split my dataset into multiple datasets baased on three variables

bayoote — Thu, 13 Feb 2020 18:23:10 GMT

Group	Product	Condition	Y
Group 1	A	10	-2
Group 1	A	10	-1
Group 1	A	20	0
Group 1	A	20	1
Group 1	A	20	2
Group 1	A	30	-19.5
Group 1	A	30	-18
Group 1	A	30	-16.5
Group 1	A	30	-15
Group 1	B	10	-14
Group 1	B	10	-13
Group 1	B	20	-12
Group 1	B	20	-11
Group 1	B	20	-10
Group 1	B	30	-9
Group 1	B	30	-8
Group 1	B	30	-7
Group 1	B	30	-6
Group 2	A	10	-2
Group 2	A	10	-1
Group 2	A	20	0
Group 2	A	20	1
Group 2	A	20	2
Group 2	A	30	-19.5
Group 2	A	30	-18
Group 2	A	30	-16.5
Group 2	A	30	-15
Group 2	B	10	-14
Group 2	B	10	-13
Group 2	B	20	-12
Group 2	B	20	-11
Group 2	B	20	-10
Group 2	B	30	-9
Group 2	B	30	-8
Group 2	B	30	-7
Group 2	B	30	-6
Hi All, Part of my datasets is like above and I want to split my dataset into multiple dataset based on group, product and condition.
For example:
my first data set will be:
Group 1	A	-2
Group 1	A	-1

my second data set will be:

Group 1	A	0
Group 1	A	1
Group 1	A	2

How can I achieve that?

Thanks!

Re: split my dataset into multiple datasets baased on three variables

svh — Thu, 13 Feb 2020 20:55:13 GMT

I think you want to use the DATA step and output more than one table. You just need to find the right statements with the correct conditional logic. The following example might work as long as Y has no missing values--remember a missing value in SAS is actually a negative number (tiny, but still a value).

Data First Second;
   Set Have;
 if Group = 'Group 1' and Product = 'A' and Y < 0 then output First;
 else if Group = 'Group 1' and Product = 'A' and Y >= 0 then output Second;
Run;

Re: split my dataset into multiple datasets baased on three variables

andreas_lds — Fri, 14 Feb 2020 06:49:06 GMT

Why do you want to split your dataset? There is hardly any good reason to do so, except the daraset is to large to use normal group-by processing.