Creating input to a macro variable from input table - SAS

Experts,

I have a table that has one column which is a list of numbers.  Is there a way to read this table one row at a time and use the information as input to a macro variable in SAS.  Because the numbers can change they cannot be hardcoded into the %MEND

Example.  

TableA
FieldA
001
002
005
010

Results I am trying to get reading in TableA
%Macro Rep(FieldA)

   Lines of Code

%MEND
%Rep(001)
%Rep(002)
%Rep(005)
%Rep(010)
moriniaAdvanced Analytics AnalystAsked:
Who is Participating?
 
Aloysius LowConnect With a Mentor Commented:
2 ways to go about this:
1. use call execute
2. read the values into multiple macro variables then loop the macro variables to call the macro

1. Using call execute
data _null_;
  set tableA;
  call execute('%rep(' || trim(left(fieldA)) || ');');
run;


2. reading into multiple macro variables and loop them
data _null_;
  set tableA;
  call symput("var" || put(_N_, best.), fieldA);
  call symput("count", _N_);
run;

%macro loop;
  %do i = 1 %to &count;
    %rep(&&var&i);
  %end;
%mend;

%loop;
0
 
moriniaAdvanced Analytics AnalystAuthor Commented:
Lowaloysius,

I am still working through the macro loop.  I am confused on how to loop the macro variables to call the macro.

If I want to create a table for each variable from the input file.  How would I loop through to get that?

 Data Table_&&var&i;
  Set File_b;
    If sex = 'F';
run;
0
 
Aloysius LowCommented:
you'll need to surround the statements with a macro like the macro loop that i wrote above:

%macro yourloop;
  %do i = 1 %to &count;
     Data Table_&&var&i;
       Set File_b;
       If sex = 'F';
     run;
  %end;
%mend;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.