Can I write the output of a 'summary' command of a 'table'-variable to a variable ?

Some answers about this were posted in 2015

https://www.mathworks.com/matlabcentral/answers/88595-can-i-write-the-output-of-a-summary-command-of-a-table-variable-to-a-variable#answer_171065

I am using Matlab 2017 and the hack suggested does not seem to work. I have made a local copy of the summary function and incorporated the fid into every fprinf as instructed. By doing this (suggested by Guilaume) I reveice the following error:

summarynew(tab);
Unrecognized variable name 'getProperty'.

Any help?

Answer 1

[Gareth]

I believe as of R2017b you can do the following:

a = summary(tab)

This will return a structure with the information that summary typically prints to the command window. I am on R2018b and here is a small example:

a = rand(10,1)
b = table(a,a)
summary(b)
c = summary(b)
c.a
% returns the following
ans = 

  struct with fields:

           Size: [10 1]
           Type: 'double'
    Description: ''
          Units: ''
     Continuity: []
            Min: 0.0975
         Median: 0.7235
            Max: 0.9649
     NumMissing: 0

Would this be a reason to move to a newer release for you?

[Luisa Liboni]

The thing is that I have near a hundred columns. I could not gatter the information manually like this. I would really like a report on everything.

[Guillaume]

There is nothing manual about GT approach. You could even convert the output structure into a table if you prefer to visualise the data into that format:

tsummary = struct2table(summary(yourtable))

[Luisa Liboni]

As I said .. I need a report.

I have to send this information, as it is printed in the screen for people who do not have matlab code knowledge.

[Gareth]

Following Guillaume's reasoning you could always do:

tsummary = struct2table(summary(yourtable));
writetable(tsummary,'myExcelfile.xlsx')