Help developing a macro with iterations

[jakarman]

if you go to sashelp.vtable you will see all the tables and their number of observations
It is a table you can process that as a table. 

[jakarman]

You can submit that code of Tom to your remote session.
Having a RLS working it will run. Is it an external RDBMS you need to have the count(*) approach. 

Some RDBMS are supporting the retrieval of metadata information.  

[damanaulakh88]

Here is the code you can use:

/*Creating Datasets*/

data a;
input name$ emp;
datalines;
aaa 121
bb 232
ccc 989
;
run;

data b;
input name$ emp;
datalines;
aaa 121
ccc 989
;
run;
data c;
input name$ emp;
datalines;
aaa 121
bb 232
;
run;
data d;
input name$ emp;
datalines;
aaa 121
bb 232
ccc 989
erf 455
;
run;

data testimportcont;
input testnumber $ table $;
datalines;
a1 a
a2 b
a3 c
a4 d
;
run;
proc sql inobs=50;
select trim(testnumber), trim(table) into :p1-:p4,:tab1-:tab4              
from testimportcont;
quit;

options mprint mlogic symbolgen;
%macro counting;
proc sql;
%do i=1 %to 4;
select count(*) into :counting1-:counting4 from &&&tab&i.;
%end;
quit;
%mend;
%counting;

=====Output=====

Hope this helps.