About

Rocket Table is a lightweight table viewer for files in SAS7BDAT, SBDF, STDF and CSV formats.

Rocket Table screenshot

Rocket Table is a successor of the SAS Table Explorer project.

Download

rocket-table-1.0.9.zip

Changelog

Features

Hotkeys

Search wildcards

Wildcard characters can be anywhere in the search string, e.g:

Search flags

Flag characters should be at the leading positions in the string, e.g:

Search examples

Search string Match result
*berry Match all rows with berries (e.g.: Blueberry, Strawberry, etc.)
CMSCAT=*THERAPY Match all medications with category name ending with "THERAPY" (e.g.: CHEMOTHERAPY, RADIOTHERAPY and HORMONAL THERAPY)
COLUMN1=VALUE1, COLUMN2=VALUE2, COLUMN3=VALUE3 Match all rows where (COLUMN1=VALUE1 AND COLUMN2=VALUE2 AND COLUMN3=VALUE3)
SEX=Male, COUNTRY=USA, DEGREE=Academic Match all men from the USA who have an Academic degree
AGE=6?, AGE=7? Match all patients aged 60-70 years old (from 60 to 79)
COLUMN1=VALUE1, COLUMN1=VALUE2, COLUMN2=VALUE3 Match all rows where ((COLUMN1=VALUE1 OR COLUMN1=VALUE2) AND COLUMN2=VALUE3)
SEX=Male, COUNTRY=USA, COUNTRY=Canada, DEGREE=Bachelor, DEGREE=Master Match all men from the USA or Canada who have a Bachelor or Master degree
COUNTRY=!USA Match all patients not from the USA
COUNTRY=!USA, GENDER=~MaLe Match all men not from the USA

Associate table files with Rocket Table in Windows

Just execute this script from the directory where the rocket-table.jar is located:

@where javaw >%TEMP%\rocket-table_javaw.var
@set /p JAVAW=<%TEMP%\rocket-table_javaw.var
@del %TEMP%\rocket-table_javaw.var

@reg add HKCU\SOFTWARE\Classes\.csv /d "rocket-table" /f
@reg add HKCU\SOFTWARE\Classes\.sas7bdat /d "rocket-table" /f
@reg add HKCU\SOFTWARE\Classes\.sbdf /d "rocket-table" /f
@reg add HKCU\SOFTWARE\Classes\.stdf /d "rocket-table" /f

@reg add HKCU\SOFTWARE\Classes\rocket-table\shell\open\command /d "\"%JAVAW%\" -jar \"%~dp0rocket-table.jar\" \"%%1\"" /f

Command line parameters

Contacts

For questions, feature requests or technical support related to this application you can contact xantorohara@gmail.com

License

Rocket Table binaries by Xantorohara are licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

Version 1.0.8, published 2015-01-10, updated 2017-03-18