File Exchange

image thumbnail

Export data to SAS

version (20.5 KB) by Dimitri Shvorob
(via Excel; with SAS/ACCESS and ActiveX Automation Server)

1 Download

Updated 04 Apr 2016

View License

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).

Cite As

Dimitri Shvorob (2020). Export data to SAS (, MATLAB Central File Exchange. Retrieved .

Comments and Ratings (6)


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.

Dimitri Shvorob

Erratum: 'sasfile and xlsfile must provide absolute file paths; file extensions may NOT be omitted'.



MATLAB Release Compatibility
Created with R14SP2
Compatible with any release
Platform Compatibility
Windows macOS Linux