BookmarkSubscribeRSS Feed
jakarman
Barite | Level 11

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. 

---->-- ja karman --<-----
jakarman
Barite | Level 11

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.  

---->-- ja karman --<-----
damanaulakh88
Obsidian | Level 7


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.

Capture.JPG

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 17 replies
  • 4106 views
  • 0 likes
  • 6 in conversation