topic Re: how to get numeric variables and character variables for all dataset in a library in SAS Programming

how to get numeric variables and character variables for all dataset in a library

BrahmanandaRao — Tue, 04 Apr 2023 04:47:23 GMT

data ds1;
set sashelp.class;
run;


data ds2;
set sashelp.cars;
run;


proc sql;
select MEMNAME into: numvar separated by " "
from dictionary.tables
where LIBNAME="WORK"
      and
MEMNAME="DATA"
      and
TYPE="num";  /*'CHAR"*/
quit;

How to get all numeric and character variables from all datasets in a library

Re: how to get numeric variables and character variables for all dataset in a library

SASKiwi — Tue, 04 Apr 2023 05:05:46 GMT

proc sql;
  create table columns as
  select *
  from dictionary.columns
  where libname = 'WORK';
quit;

Re: how to get numeric variables and character variables for all dataset in a library

yabwon — Tue, 04 Apr 2023 07:12:05 GMT

proc contents data=WORK._ALL_ out=Variables noprint;
run;

Re: how to get numeric variables and character variables for all dataset in a library

BrahmanandaRao — Tue, 04 Apr 2023 10:03:27 GMT

Thank you very munch yabwon for your solution