DATA Step, Macro, Functions and more

Macro PArameters

Accepted Solution Solved
Reply
Super Contributor
Posts: 1,040
Accepted Solution

Macro PArameters

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


Accepted Solutions
Solution
‎10-22-2012 08:35 PM
Super User
Posts: 17,796

Re: Macro PArameters

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;

View solution in original post


All Replies
Solution
‎10-22-2012 08:35 PM
Super User
Posts: 17,796

Re: Macro PArameters

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;

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 153 views
  • 0 likes
  • 2 in conversation