topic splitting a data set into multiple data sets by using macro in SAS Programming

split a data set into multiple data sets using macro

Ronein — Sun, 04 Nov 2018 07:36:53 GMT

Hello

I am trying to split a data set into multiple data sets.

In this example I get 5 data sets but the variable contains only 4 unique values.

What is the error in

data have;
infile datalines truncover;
input @1 deptid 1. deptdescription $ & 3-20;
datalines;
1 Maths
2 Astronomy
1 Maths
3 Physics
4 Public Health
3 Physics
;
run;
proc sort data=have;
by deptid;
run;
data _null_;
set have;
by deptid;
if first.deptid then do;
i+1;
call symputx('subj'|| left(put(i,2.)),deptdescription);
end;
if last.deptid then call symputx('total',i);
run;
%put &subj1;/*Maths*/
%put &subj2;/*Astronomy*/
%put &subj3;/*Physics*/
%put &subj4;/*Public Health*/
%put &total;/*4*/
 
%macro mmacro;
%do i=1 %to &total.;
data &&subj&i;
set have;
where deptdescription="&&subj&i";
run;
%end;
%mend mmacro;
%mmacro;

code?

splitting a data set into multiple data sets by using macro

Ronein — Sun, 04 Nov 2018 07:29:04 GMT

Hello

I want to ask a question about splitting a data set into multiple data sets by using macro.

In the following example there are 4 unique values to variable deptdescirption.

Why in the result there are 5 data sets?

What is the mistake in code here?

Why for value "Public Health" there are 2 data sets??

data have;
infile datalines truncover;
input @1 deptid 1. deptdescription $ & 3-20;
datalines;
1 Maths
2 Astronomy
1 Maths
3 Physics
4 Public Health
3 Physics
;
run;

proc sort data=have;
by deptid;
run;

data _null_;
set have;
by deptid;
if first.deptid then do;
i+1;
call symputx('subj'|| left(put(i,2.)),deptdescription);
end;
if last.deptid then call symputx('total',i);
run;
%put &subj1;/*Maths*/
%put &subj2;/*Astronomy*/
%put &subj3;/*Physics*/
%put &subj4;/*Public Health*/
%put &total;/*4*/
 
%macro mmacro;
%do i=1 %to &total.;
data &&subj&i;
set have;
where deptdescription="&&subj&i";
run;
%end;
%mend mmacro;
%mmacro;

Re: split a data set into multiple data sets using macro

Kurt_Bremser — Sun, 04 Nov 2018 08:07:18 GMT

"Public Health" is not a valid SAS name.

Re: splitting a data set into multiple data sets by using macro

VDD — Sun, 04 Nov 2018 15:31:51 GMT

those are all very good questions to ask.

Research and prior understanding of SAS tools you are requesting answers to would answer these basics questions like the space in the deptdescirption for deptid 4.

Know your data, have a basic understanding of the tools you are trying to use.