File Exchange

image thumbnail

Export data to SAS

version 1.0.0.0 (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 (https://www.mathworks.com/matlabcentral/fileexchange/15834-export-data-to-sas), MATLAB Central File Exchange. Retrieved .

Comments and Ratings (6)

Marco

Hello:
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?
Thanks!!!

Philip

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

Updates

1.0.0.0

BSD

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

saswrite/html/