topic Re: Macros to run proc univariate on multiple tables in an ODBC and saving it in a single table in SAS Enterprise Guide

Macros to run proc univariate on multiple tables in an ODBC and saving it in a single table

phoenix31 — Wed, 17 May 2017 13:37:17 GMT

Creation of macros to run proc univariate on multiple tables from the ODBC (Oracle Server) and saving this in a single table.

I have around 40 tables in a particular schema on the Oracle server and would like to run Proc univariate on all the numeric fields from the tables and save it in a single table.

I know this is limited information, but I wanted to start with the high level and provide more information based on the updates I receive.

Thank you so much!

Re: Macros to run proc univariate on multiple tables in an ODBC and saving it in a single table

PaigeMiller — Wed, 17 May 2017 14:04:47 GMT

Write a macro that loops through all of the Oracle tables and performs PROC UNIVARIATE on it, with results being stored in a SAS data set. In the same loop, append each SAS data set to the previous (PROC APPEND).

Re: Macros to run proc univariate on multiple tables in an ODBC and saving it in a single table

RW9 — Wed, 17 May 2017 14:28:46 GMT

Much like @PaigeMiller you have provided the high level, so nothing further for us to comment on.

If it was me doing it I would break it down as:

1) Get data from database and save to SAS datasets in a given library.

2) Generate the code from SASHELP.VTABLE, something like:

data _null_;
  set sashelp.vtable (where=(libname="YOURLIB"));
  call execute('proc univariate....;
                    proc append base=...);
run;