topic Re: Macro to split a Data set into smaller Datasets depending on the Unique value of each variable in SAS Programming

Macro to split a Data set into smaller Datasets depending on the Unique value of each variable

SASnewbie4 — Wed, 14 Nov 2018 15:46:44 GMT

Suppose I got Order placed from US, CA Today, so I call the macro and it will split the master data into 2 data US and CA having those observation. Tomorrow suppose I have order placed from CH, JP, IN and AU, I call same macro and it will split master data into 4 smaller Data.
Example input: %macroname('US', 'CA') or %macroname('CH', 'JP', 'AU', 'IN')

Re: Macro to split a Data set into smaller Datasets depending on the Unique value of each variable

Reeza — Wed, 14 Nov 2018 16:02:29 GMT

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

Re: Macro to split a Data set into smaller Datasets depending on the Unique value of each variable

Reeza — Wed, 14 Nov 2018 16:02:52 GMT

And the general advice is don't do this, it's usually inefficient for whatever else you're trying to do.

Re: Macro to split a Data set into smaller Datasets depending on the Unique value of each variable

novinosrin — Wed, 14 Nov 2018 16:08:48 GMT

HI @SASnewbie4 Welcome to the SAS forum.

You should be able to find your answer in this thread

https://communities.sas.com/t5/New-SAS-User/Using-an-Array-to-output-multiple-datasets-by-year-of-record/m-p/512726#M2426

Take @hashman 's solution with eyes closed. Supposing you are not aware who is hashman, the only way to put that is there is perhaps only one synonym of SAS and that's that.

Guru @hashman Sorry for the plug early morning, but i thought to get a newbie to peek your addr and poke the hash. 🙂

Re: Macro to split a Data set into smaller Datasets depending on the Unique value of each variable

SASnewbie4 — Wed, 14 Nov 2018 16:15:28 GMT

Thanks for replying.

I just started learning SAS and so I am wondering if there is a way to do it. I did go through the link you shared with me but what I am trying to figure out is if I can split the data based on the Macro I call (For Example: %macroname('US', 'CA') or %macroname('CH', 'JP', 'AU', 'IN')). I am not even sure if it can be done as I have been looking for a solution for the past few days now but with no luck.

Please help if you can. Thanks again.