Export data to SAS

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

Description

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

Acknowledgements

The author wishes to acknowledge the following in the creation of this submission:
The Twain Shall Meet: Facilitating Data Exchange between SAS and Matlab

• MATLAB release: MATLAB 7.0.4 (R14SP2)
• Other requirements: SAS/ACCESS Interface to PC Files, Microsoft Excel

[Dimitri Shvorob]

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

[Alessandro Juri]

 

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

[Alessandro Juri]

 

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

[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!!!