No BSD License  

Highlights from
Export data to SAS

image thumbnail

Export data to SAS

by

 

05 Aug 2007 (Updated )

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

SASWRITE

SASWRITE

Write numeric data to a SAS dataset

Contents

Syntax

saswrite(array,sasfile,xlsfile)

saswrite(array,sasfile,xlsfile,names)

Inputs

array - numeric array

sasfile - full path to input SAS dataset

xlsfile - full path to Excel workbook containing SAS2Excel macro

names - SAS column names, cell array of strings (optional)

Outputs

(none)

Description

saswrite invokes xlswrite to write array to a temporary Excel workbook, then uses Microsoft Excel, manipulated via ActiveX automation server, to open an instance of SAS and execute IMPORT procedure, transferring data to a SAS dataset.

Both SAS (including SAS/ACCESS Interface to PC Files) and Excel are needed to run saswrite. Excel workbook containing SAS2Excel macro must be retained, its path provided in xlsfile.

C:\sas.xls is used for temporary data storage; if you do not have write access to C:, edit all references to C:\sas.xls in sasread and SAS2Excel macro.

saswrite will ask you to close any open SAS sessions.

During transfer, you will be presented with a 'Save changes?' dialog by Excel; select 'Do not save changes'. (Suggestions on how to suppress this behavior are welcome).

sasfile and xlsfile must provide absolute file paths; file extensions may be omitted.

Example

array = rand(2)                                 %#ok
array =

    0.4154    0.8744
    0.3050    0.0150

dir('C:\*.sas7bdat')
sasreaddemo.sas7bdat  

sasfile = 'C:\saswritedemo.sas7bdat';
xlsfile = 'C:\SAS-Matlab Converter.xls';
saswrite(array,sasfile,xlsfile)
dir('C:\*.sas7bdat')
sasreaddemo.sas7bdat   saswritedemo.sas7bdat  

[numeric,text,raw] = sasread(sasfile,xlsfile)   %#ok
numeric =

    0.4154    0.8744
    0.3050    0.0150


text = 

    'F1'    'F2'


raw = 

    'F1'        'F2'    
    [0.4154]    [0.8744]
    [0.3050]    [0.0150]

See also

sasread (companion File Exchange submission)

xlsread

actxserver

Author

Dimitri Shvorob, dimitri.shvorob@vanderbilt.edu, 11/1/05

Contact us