Macro PArameters

[robertrao]

Hi Team,

In this piece of code we have where proc_code in(&code)

While we call this macro why are we not putting a comma between the codes????If we try to then it doesnt work?There is an error which says positional precedes keyword!!!!

%macro cohorts(want=,code=,group=);

data &want(drop=BMI)

length Category $25.;

set chat(keep= sex BMI name age gender)

where Proc_code in(&code);

%mend;

%cohorts(want=red, code="151" "152" "153" "154" "155" group=thamba);

                                                                ^

                                                                |

                                                                |

                                                   no commas placed as seperators!!!

Thanks

[Reeza · Accepted solution]

Nope and you don't need them in 'regular' sas code either:

data test;

set sashelp.class;

where age in (12 13 14 15);

run;

data test2;

set sashelp.class;

where name in ("Alfred" "Alice" "William");

run;