Create a variable with count of obs in all files in a folder

[texasmfp]

I am using the following code to create a dataset of the file names for all SAS datasets within a specified folder (I then trim part of the filename in the second step).  I want to add a second field, one that includes the number of observations in each of the named datasets.  Thoughts?  Thanks in advance.

proc sql;
CREATE TABLE CULL AS
select catx('.',libname,memname) into :setnames separated by ' '
from dictionary.tables
where libname = 'RESULTS';
quit;

DATA Cull ;
SET CULL;
_TEMA001=tranwrd(_TEMA001,"RESULTS.TARGETS_","");
RUN;

[hhinohar · Accepted solution]

proc sql;
CREATE TABLE CULL AS
select catx('.',libname,memname) ,nobs into :setnames,:nobs separated by ' '
from dictionary.tables
where libname = 'RESULTS';
quit;

Like this?

https://documentation.sas.com/?cdcId=vdmmlcdc&cdcVersion=1.0&docsetId=mcrolref&docsetTarget=n1y2jszl...