topic Re: create excel with collapse/expand columns function in ODS and Base Reporting

create excel with collapse/expand columns function

rufmau68 — Wed, 21 Nov 2018 13:59:12 GMT

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

Re: create excel with collapse/expand columns function

RW9 — Wed, 21 Nov 2018 14:10:43 GMT

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.