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.
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.