Is the issue that the hyperlinks are not working or is the file not opening in Excel? ... View more

@hartwell Sorry, I did not read closely enough. This information which is selected does not get stored in a location that can be retrieved. However, if you are interested in the selected information, you could in tandem create an ODS DOCUMENT with the selected information and replay this. See the following example.   ods rtf file="c:\temp\temp1.rtf"; /* Print selected output and create an ODS Document with the selected output  */ ods select all; ods document name=temp; proc freq data=sashelp.class; run; ods select none; proc print data=sashelp.class; run; ods document close; ods rtf close;   /* Display the selected output */ proc document name=test(update); replay; quit; ... View more

One method of doing this as you mentioned is to use the SASHELP.VDEST table. Does this work for you? Either in SQL using the Dictionary.vdest table or in the DATA step. data temp; set sashelp.vdest; run;   ... View more

This is also documented in the V8 layout. A SAS Note will also be added. SAS Help Center: Record Layout for a SAS Version 8 or 9 Data Set in SAS Transport Format   Observation header: The "0" at the end of the header specifies the number of observations in each data set for the OBSV8 header. In this example, there are 0 observations.   HEADER RECORD*******OBSV8 HEADER RECORD!!!!!!!000000000000000000000000 000000 Here is another header example. The "1" at the end of the header specifies the number of observations in each data set for the OBSV8 header. HEADER RECORD*******OBSV8 HEADER RECORD!!!!!!! 1   ... View more

ODS Excel doesn't have the capability of creating grouped data currently. This has been added as a suggested feature. ... View more

Mentioned by Ksharp, linking with Excel is a little different than the other destinations.  The ANCHOR= option with ODS Excel is only applicable when using CSS stylesheets. ... View more

This appears to be a defect. The first character of "$" in the format is causing an issue where the values are passed through rather than applying the formatted value.  I will get a defect entered on this problem so we can get this fixed. Feel free to open a case with Technical Support and I will have more details after this is fully debugged.     ... View more

Hello, If you want to generate the pivot table without having to select the export button from the HTML page, you can use the other method of generating the pivot table. This method requires that you point to an an existing Excel/HTML/XML/CSV file or create one that can be used as the data source to the pivot table. The TableEditor tagset can then point to this data and with options generate the JavaScript processing instructions on how to generate the pivot tables. The below blog explains this in detail, please let me know of any problems.   https://blogs.sas.com/content/sgf/2015/03/27/using-sas-to-add-pivottables-to-your-excel-workbook/   Sincerely, Chevell   ... View more

The row can also be hidden using the HIDDEN_ROWS= suboption like the below.   ods excel file="c:\temp.xlsx" options( sheet_interval="none" hidden_rows="21"); proc print data=sashelp.class; run; proc print data=sashelp.class; run; ods excel close; ... View more

Make sure that the table header names in the source worksheet and HTML table match the fields Value1-Value5 that you have included with the PivotData= option. For instance, make sure that you don't have them displayed with labels and use the actual column names in the option. The table headers should match the values specified in the  Pivotdata= option.   ... View more