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

texasmfp — Sun, 15 Nov 2020 07:31:40 GMT

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;

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

hhinohar — Sun, 15 Nov 2020 08:16:05 GMT

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=n1y2jszlvs4hugn14nooftfrxhp3.htm&locale=en

topic Create a variable with count of obs in all files in a folder in SAS Programming

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

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