File Exchange

image thumbnail

Export data to SAS

version 1.0 (20.5 KB) by

(via Excel; with SAS/ACCESS and ActiveX Automation Server)



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

Comments and Ratings (6)


Marco (view profile)

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?


Philip (view profile)

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.

Dimitri Shvorob

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
MATLAB 7.0.4 (R14SP2)

Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.

» Watch video