topic Re: Varying Parameters in SAS Programming

Varying Parameters

SASPhile — Tue, 17 May 2011 14:35:47 GMT

sgrp1 and sgrp2 can both have parameter values or there could be only one value passed.
in the below code there values for both sgrp1 and sgrp2.
so the dataset to be created is stage4046.

if there is value for sgrp1 and no value for sgrp2.
say sgrp1 is 5.the where condition will fail due to syntax errors.

is there a way to automate this,no matter how many values we pass?

%macro stage(sgrp1=,sgrp2=)
data stage&sgrp1.&sgrp2.;
set Clsindx(where=(slsgrp in (&sgrp1,&sgrp2)));
run;
%mend clsstage;
%clsstage(sgrp1=40,sgrp2=46);

Re: Varying Parameters

data_null__ — Tue, 17 May 2011 14:44:03 GMT

IN operator will accept blank delimited lists.

Re: Varying Parameters

andreas_lds — Tue, 17 May 2011 15:07:47 GMT

Maybe this helps:

[pre]
%macro filter(ages=);
%local datasetPostfix;
%let datasetPostfix = %sysfunc(compress(&ages, %str( )));
data work.Class&datasetPostfix;
set sashelp.class;
where age in (&ages);
run;
%mend;

%filter(ages=13 15);[/pre]

Works as long as you pass at least one value.