create excel with collapse/expand columns function

[rufmau68]

hi, 

im new sas base user and i need to create an excel report with "+/- functions".

with "+/- functions" i mean collapse/expand functions that able user to hides or shows any column nor any rows

its possible to do it ?

thanks 

bye

mauro

[RW9 · Accepted solution]

No, its not.  SAS can create Excel files with data, formatting, and some features, like formulas.  It does not however encapsulate the whole suite of Excel abilities.  To do such a thing you would create your template Excel file, and get that to read in your data from a SAS exported file, or have some VBA code to create it from an exported file.

If your that into using Excel that you need these types of things, then why bother with SAS?  Just dump out to CSV, then have Excel/VBA process that data into the format you need.