5.2.16. (old) SAS file reader

<< Click to Display Table of Contents >>

Navigation:  5. Detailed description of the Actions > 5.2. Input Actions >

5.2.16. (old) SAS file reader

 
Icon: ANATEL~2_img233

 

Property window:

 

ANATEL~2_img345

 

Short description:

Reads a table from a .sas7bdat file

 

Long Description:

See section 5.1.1 to have more information on how to specify the filename of the .sas7bdat file (i.e. You can use relative path, wildcards, and Javascript to specify your filename).

 

You should rather use the new ANATEL~2_img228  readStat Action to read .sas7bdat files.

 

 

ANATEL~2_img8

Pre-requisite

To be able to import SAS files inside Anatella using the ANATEL~2_img233 readSAS Action, you need first to install the “SAS OleDB provider” inside your system. You need administrative rights to install the “SAS OleDB provider”. You don’t need to install the complete SAS software in your system to be able to use the “SAS OleDB provider” because it’s a complete stand-alone, self-contained driver. Installation is thus very easy: you only need a few mouse-clicks.

 

The “SAS OleDB provider” is a small & free driver available from the SAS website. For your convenience, a local copy is also available on the Anatella website, here:

http://download.timi.eu/ThirdParty/sasoledb_64bit_and_32bit.zip

 

To install the “SAS OleDB provider”, unzip the archive, double-click the “setup.exe” file and select these 2 options

 
:     ANATEL~2_img350

 

 

 

Here is an example:

 

ANATEL~2_img351

 

 

There are two different ways to store dates inside SAS: Dates can either be stored as Strings or Floating point numbers (SAS is very similar to Anatella with respect to dates). The dates that are stored inside SAS as floating point numbers are imported inside Anatella as floating point numbers (i.e. with a blue background color inside the data Preview window). To convert these dates to “normal” Anatella dates, you can use the “to String from Elapsed Time” option of the ChangeDataType ANATEL~2_img9  Action. Use these parameters:
 

Reference Time: 19600101 00:00:00

Elapsed Time Unit: day.

 

Here is a screenshot:
 

ANATEL~2_img240