No BSD License  

Highlights from
Export data to SAS

5.0

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

Export data to SAS

by

 

05 Aug 2007 (Updated )

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

| Watch this File

File Information
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 Twain Shall Meet: Facilitating Data Exchange Between Sas And Matlab inspired this file.

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

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

15 Jul 2010 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.

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.

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

Contact us