topic Re: Export Proc Contents in ODS and Base Reporting

Export Proc Contents

rfarmenta — Wed, 21 Aug 2013 23:28:47 GMT

Is there a way to export proc contents to an excel file? It would be nice to have the variable name, the label, and the format name to easily create a data dictionary. I have tried a couple different ways but they never come out right. Thanks in advance.

Re: Export Proc Contents

Scott_Mitchell — Wed, 21 Aug 2013 23:57:14 GMT

You just need an out=<dsname> in your code and then export it to excel in the usual manner.

proc contents data=sashelp.class out= want;

run;

Re: Export Proc Contents

whijazi — Mon, 06 Apr 2015 14:52:58 GMT

Can you please provide a code example?

Re: Export Proc Contents

Reeza — Mon, 06 Apr 2015 15:39:55 GMT

You can also use the SASHELP.VCOLUMN and get the information from there, use KEEP to keep the variables you need.

data data_dictionary;

set sashelp.vcolumn;

where upper(libname)='SASHELP' and upper(memname)='CLASS';

run;

Re: Export Proc Contents

ballardw — Mon, 06 Apr 2015 16:51:35 GMT

Or sent the output to excel at the same time:

ods tagsets.excelxp file="my soon to be Excel.xml";

proc contents data=have; run;

ods tagsets.excelxp close;

The XML file generated can be opened in Excel and if desired saved to native Excel format.