The SAS Output Delivery System and reporting techniques

Export Proc Contents

Reply
Regular Contributor
Posts: 150

Export Proc Contents

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.

Super Contributor
Posts: 297

Re: Export Proc Contents

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;

Occasional Contributor
Posts: 12

Re: Export Proc Contents

Can you please provide a code example?

Super User
Posts: 11,104

Re: Export Proc Contents

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.

Super User
Posts: 19,023

Re: Export Proc Contents

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;

Ask a Question
Discussion stats
  • 4 replies
  • 4497 views
  • 3 likes
  • 5 in conversation