topic Re: Exporting table properties in SAS Enterprise Guide

Exporting table properties

mczeg — Tue, 09 Feb 2016 14:07:42 GMT

Is there any way to export a datasets properties to excel? What I mean by this is that in EG if you right click on a data set, select properties and then the columns tab, SAS displays the Name, Type, Length, Format, etc for that table. I'm looking for a way to export this exact same data into excel in order to create a type of quick reference/data dictionary. Is anyone aware if this is possible?

Thank you

Re: Exporting table properties

Reeza — Tue, 09 Feb 2016 14:09:22 GMT

There's a couple of different ways - one is to write a proc contents and export those results to excel.

proc contents data=have;run;

Re: Exporting table properties

LinusH — Tue, 09 Feb 2016 14:30:44 GMT

Also, you can get this information from SASHELP.Vxxxx views, which holds inforamtion for all datasets/views available to the SAS session. VSTABLE and VCOLUMN if remember correctly could be of interest.

Re: Exporting table properties

ChrisHemedinger — Tue, 09 Feb 2016 14:38:18 GMT

For adhoc applications, you can simply copy/paste the attributes from the Data summary into Excel.

For a programming approach, you can output the details in PROC DATASETS and export to Excel using either PROC EXPORT or ODS EXCEL:

proc datasets lib=sashelp nolist  ;
  contents data=class out=work.classattr;
quit;

/* requires SAS/ACCESS to PC Files */
proc export data=classattr  
  file="c:\temp\attr.xlsx" 
   dbms=xlsx replace;
run;

/* Base SAS in 9.4m2 or later */
ods excel file="c:\temp\attr_ods.xlsx" ;
  proc print data=classattr; run;
ods excel close;

Chris

Re: Exporting table properties

mczeg — Tue, 09 Feb 2016 15:13:35 GMT

Thanks all for the information