topic How to create multiple dataset from one dataset? in SAS Data Science

How to create multiple dataset from one dataset?

mlogan — Sun, 15 Feb 2015 23:08:13 GMT

Can anyone tell me what would be the code for creating multiple dataset from one dataset in one data step?

Example: I have the following info dataset

Name City Country

John New York USA

Albert Toronto Canada

Alice Sydney Australia

I want to create 3 dataset called USA, Canada and Australia from info dataset above. I tried the following way, but it's not working:

data usa canada australia;

set info;

if country='usa' then output usa;

if country='Canada' then output Canada;

if country='Australia' then output Australia;

run;

can anyone help please. Thanks.

Re: How to create multiple dataset from one dataset?

ChrisHemedinger — Tue, 17 Feb 2015 19:29:26 GMT

Here's an article that I wrote recently:

http://blogs.sas.com/content/sasdummy/2015/01/26/how-to-split-one-data-set-into-many/

Be sure to read the comments, as several other experts have weighed in with improvements.

Chris

Re: How to create multiple dataset from one dataset?

art297 — Tue, 17 Feb 2015 19:46:45 GMT

I seem to recall someone already answering this last week. One of your records shows the country as USA, but your if statement is looking for usa.

Re: How to create multiple dataset from one dataset?

ChrisHemedinger — Tue, 17 Feb 2015 20:10:01 GMT

Here's the other thread:

With some of the spam activity, we've seen some people add messages more than once because messages by brand new users are moderated. We've been trying to weed out the duplicates, but some still slip through.

Chris

Re: How to create multiple dataset from one dataset?

FriedEgg — Tue, 17 Feb 2015 21:15:42 GMT

Consider whether you really need to split this dataset of if you are better off processing using BY or CLASS statements.