split a data set into multiple data sets using macro

[Ronein]

Hello

Let's say that I want to split data set sashelp.cars into multiple datasets by the value of field "Length".

I expect to get 67 data sets because there are 67 distinct values of field "Length".

for example:

Name of data set for rows with Length=143 should be tbl_143

Name of data set for rows with Length=169 should be tbl_169

What is the clever way to do it please?

[gamotte]

Hello,

I would say that the clever way to do it is not to do it and rather use by group processing.

proc sql;
    CREATE TABLE cars AS
    SELECT DISTINCT length
    FROM sashelp.cars;
quit;

data _NULL_;
    set cars;
    call execute(cats('data tbl_',length,'; set sashelp.cars; where length=',length,'; run;'));
run;

[PaigeMiller]

---

@gamotte wrote:

Hello,

I would say that the clever way to do it is not to do it and rather use by group processing.

Yes, indeed! Not splitting up data sets is the most clever thing to do, because it simplifies your programming and takes advantage of things SAS has already programmed for your benefit.

[PeterClemmensen]

@Reeza wrote a macro for this exact purpose.

https://communities.sas.com/t5/SAS-Communities-Library/Splitting-a-SAS-data-set/ta-p/517960