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).
Dimitri Shvorob (2020). Export data to SAS (https://www.mathworks.com/matlabcentral/fileexchange/15834-export-data-to-sas), MATLAB Central File Exchange. Retrieved .
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'.