08-21-2013 07:28 PM
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.
04-06-2015 12:51 PM
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.
04-06-2015 11:39 AM
You can also use the SASHELP.VCOLUMN and get the information from there, use KEEP to keep the variables you need.
where upper(libname)='SASHELP' and upper(memname)='CLASS';