Macro Variable

[kindbe17]

Hi, could you please help me with this?

i should Create macro variable that will be used to filter the dataset BASEBALL to keep observation where player’s Surname isn’t starting with “W” letter.

Create a macro program to count how many players are playing –

1. in the same DIV and in the same TEAM,
2. in the same LEAGUE and at the same POSITION.

[PeterClemmensen]

What have you tried so far?

[kindbe17]

I start with this code and stopped because i don't know what to do, could you please help me?

data base;
set sashelp.baseball;
run;

%let name=basename;
data &name.123;
base=3;
run;

[Oligolas · Accepted solution]

%let whereCond=%str(where name^=:'W');
DATA test;
   set sashelp.baseball;
   &whereCond.;
RUN;

%MACRO countPlayers(inputDS=,var1=,var2=);
   proc freq data=&inputDS.;
   table &var1.*&var2. /norow nocol nopercent;
   run;
%MEND countPlayers;

%countPlayers(inputDS=test,var1=div,var2=team);
%countPlayers(inputDS=test,var1=league,var2=position);