topic Macro Variable in SAS Programming

Macro Variable

kindbe17 — Thu, 20 Apr 2023 06:58:25 GMT

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 –

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

Re: Macro Variable

PeterClemmensen — Thu, 20 Apr 2023 07:29:27 GMT

What have you tried so far?

Re: Macro Variable

kindbe17 — Thu, 20 Apr 2023 07:33:52 GMT

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;

Re: Macro Variable

Oligolas — Thu, 20 Apr 2023 07:36:22 GMT

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