split my dataset into multiple datasets based on three or more variables

[bayoote]

Hi All,

Attached is part of my datasets.  I want to split the dataset into multiple datasets based on the Group, Product, Condition.

Any suggestions? Thanks!

[Reeza]

Why? This isn't recommend usually because there are multiple ways to process data by groups without splitting them up or ways to export the data without first having to create multiple data sets. So explaining what your end goal is will help us provide a better solution.

[bayoote]

Hi, Thanks for your reply. Since I want to do the interpolation for each small group.That's why I need to split the dataset.

[PaigeMiller]

You do whatever analysis you are planning using the BY statement. Leave everything in one data set.

[Reeza]

Yeah, you don't need to do that in SAS. You can use BY to treat each group separately. For example, this will produce a regression model for each origin, entirely separately.

proc sort data=sashelp.cars out=cars;
by origin;
run;

proc reg data=cars;
by origin;
model Mpg_city = weight cylinders msrp;
run;

---

@bayoote wrote:
Hi, Thanks for your reply. Since I want to do the interpolation for each small group.That's why I need to split the dataset.

---

[PeterClemmensen]

Is there a good reason why you want to do this? Generally, it is not advisable.