How to use PROC CONTENTS Output Using the ODS Excel Destination?

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #49338
    rlochan2021
    Keymaster

    THE FULL CODE FOR THIS EXAMPLE
    Below is the full code for this example.
    libname asj oracle
    user=asjview
    password=asjview
    path=jailprod.world
    schema=asjdba
    access=readonly;
    run;
    ods output variables=AllOracleVarOut;
    proc contents data=asj._all_;
    run;
    proc sort data=AllOracleVarOut;
    by member num;
    run;
    options nobyline;
    ODS EXCEL FILE=”H:\SESUG 2015\all_variables_from_Oracle_database.xlsx”
    options(sheet_name=”#BYVAL(member)”
    embedded_titles=’yes’);
    proc print data=AllOracleVarOut noobs;
    by member;
    pageby member;
    title “Variables in #BYVAL(member) table”;
    run;
    ODS EXCEL CLOSE;

    Source-

    https://www.lexjansen.com/sesug/2015/76_Final_PDF.pdf

Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.