View License

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

» Watch video

Highlights from
Export data to SAS

5.0 | 2 ratings Rate this file 5 Downloads (last 30 days) File Size: 20.5 KB File ID: #15834 Version: 1.0
image thumbnail

Export data to SAS



05 Aug 2007 (Updated )

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

| Watch this File

File Information

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


The Twain Shall Meet: Facilitating Data Exchange Between Sas And Matlab inspired this file.

MATLAB release MATLAB 7.0.4 (R14SP2)
MATLAB Search Path
Other requirements SAS/ACCESS Interface to PC Files, Microsoft Excel
Tags for This File   Please login to tag files.
Please login to add a comment or rating.
Comments and Ratings (6)
29 Jul 2011 Marco

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?

Comment only
15 Jul 2010 Philip

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.

Comment only
28 Sep 2009 Alessandro Juri

05 Sep 2009 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.

Comment only
27 Aug 2009 Alessandro Juri

07 Aug 2007 Dimitri Shvorob

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

Comment only
04 Apr 2016 1.0


Contact us