Please see SASWRITEDEMO, by following link 'Published m-files' below.
PS. In retrospect, SASWRITE gets credit for an inventive approach, but for practical purposes, I would strongly recommend MySQL-mediated data transfer, discussed in 'The Twain Shall Meet: Facilitating Data Exchange between SAS and Matlab' (see link below).
how many rows can be saved in one step? Does Excel constraint the process in any way?
MySQL-mediated data transfer would be preferable but I find it very slow to go from SAS to MySQL to Matlab to MySql, especially when I transfer large SAS tables to MySql (over a million rows). Is there a way to speed up the process? do you have any hints?
I'm getting an error while attempting to use this function while saswrite attempts to use the .xls file.
Run-time error '91':
Object variable or With block variable not set.
This occurs while running the demo.
Apparently, the two-star ranking stems from Alessandro not finding the XLS file. Does anybody else not see it? Please give me a shout.
Erratum: 'sasfile and xlsfile must provide absolute file paths; file extensions may NOT be omitted'.
Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.