topic split my dataset into multiple datasets based on three or more variables in SAS Programming

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

bayoote — Thu, 13 Feb 2020 18:33:14 GMT

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!

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

Reeza — Thu, 13 Feb 2020 18:49:24 GMT

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.

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

PeterClemmensen — Thu, 13 Feb 2020 19:49:08 GMT

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

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

bayoote — Sun, 16 Feb 2020 22:03:46 GMT

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.

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

PaigeMiller — Sun, 16 Feb 2020 22:11:00 GMT

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

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

Reeza — Mon, 17 Feb 2020 00:08:54 GMT

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.