SAS macro - to creating multiple tables

dht115 — Wed, 22 Dec 2021 13:54:30 GMT

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);

Re: SAS macro - to creating multiple tables

Kurt_Bremser — Wed, 22 Dec 2021 14:01:12 GMT

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;

topic SAS macro - to creating multiple tables in SAS Programming

SAS macro - to creating multiple tables

Re: SAS macro - to creating multiple tables