SAS macro - to creating multiple tables

[dht115]

Hello, 

I am trying to create multiple tables by using the SAS macro. 

/*Create test_a and test_b tables by using the sas macro*/
/*test_a should keep only type variable in the output*/
/*test_b should keep only make variable in the output*/

%macro test1(test=, req=);
data count_by_"&test1.";
	set sashelp.cars(keep= req.);
run;
%mend;
%test1(test=test_a, req=type);
%test1(test=test_b, req=make);

[Kurt_Bremser · Accepted solution]

• quotes are not allowed in dataset names
• make sure you use the correct name (test <> test1!)
• macro parameters must always be addressed like macro variables, with a leading ampersand

%macro test1(test=, req=);
data count_by_&test.;
set sashelp.cars(keep=&req.);
run;
%mend;