DsShell

Version 2.2, 2014-12-12

DsShell: a Windows shell extension for working with SAS® data sets, as produced by the SAS System, the World Programming System, StatTransfer and others.

With DsShell installed, you can:

  • right-click on any supported SAS data set file and convert it to CSV format, for import into spreadsheets and other data analysis software
  • use the Preview Pane to easily view your data, right in the Explorer window
  • add extra property columns (such as the data set label, number of observations and the number of variables to name just a few) to the Details view in Explorer
  • see key data set details in a tool tip when you hover the mouse over a data set file
  • ...and much more!

DsShell works on Windows Vista, 7, 8, 8.1 and 10. No other software is required.

These screenshots show DsShell being used to convert first one, and then several, SAS data sets to CSV. Just right-click on the files in Explorer and choose the relevant 'Convert to .csv' option'.

Preview Pane: The screenshot below shows the new DsShell preview handler in action. Simply turn on the Preview Pane in Windows Explorer, select any supported SAS data set, and view your data in Explorer - no additional software required.

Properties: DsShell now includes a property handler for SAS data sets; the property handler allows Windows Explorer to display key information about your data sets in various places, including the Details view:

the Details Pane:

and the Details tab of the Properties dialog:

This dialog shows the full set of 12 properties currently supported by DsShell's property handler - you can add any of these to the Details view by right-clicking on a column header, selecting 'More...' and then scrolling through the list to find the property names as shown above.

The Windows Search subsystem will also index all your data set files according to these properties, making it easy to search for data sets according to their labels, etc.

DsShell can read SAS data sets from a wide variety of platforms, including 32-bit Windows and Linux, 64-bit Windows and Linux, Solaris and others. The trial version will work with any data set created in 32-bit Windows format - other formats cannot be read until you register DsShell (just US$75 - see below for details).

Download

Choose the appropriate installer below, download it and run it - your browser may offer to run it for you, or you may need to double-click it to start the installation - this depends on your choice of browser. As DsShell is a Windows Explorer shell extension, you must install the correct version for your system - if you have 32-bit Windows, you need the 32-bit version of DsShell and if you have 64-bit Windows, you need the 64-bit version of DsShell.

32-bit

dsshell-2.2-installer-32.msi (1,040 Kb)
64-bit

dsshell-2.2-installer-64.msi (1,068 Kb)

During installation of DsShell, you will be required to read and accept the End User License Agreement (EULA). The EULA for DsShell is also available here, if you'd like to read it before downloading.

Uninstallation Instructions

If you choose to uninstall DsShell, follow these instructions:

From the Start menu (or Start screen, on Windows 8/8.1), select the Control Panel, then 'Uninstall a program'. Select DsShell in the list of installed programs, then click 'Uninstall'.

Registration

This version of DsShell is a free trial which you can download to make sure that it does everything that you want. If you decide to carry on using DsShell, you should buy a dsread registration code via RegNow by clicking here (a dsread registration code is good for dsread and DsShell!). Registration costs US$75 for a lifetime license which will work with all future versions of both dsread and DsShell at no extra cost; please enquire for multi-user and academic discounts.

Some functions of DsShell are restricted until you get your registration code - only datasets created on 32-bit Windows platforms will be convertable or previewable in the trial version.

To register DsShell, first buy a registration code at the link above, then right-click on any SAS data set and select DsShell's 'Convert to .csv' option. From the DsShell dialog click About... and enter the registration name and code you received by email after registering.

Limitations

Despite thorough testing, Oceanview Consultancy Ltd cannot guarantee that the output of this software will be accurate in all cases. You use it at your own risk.

It will work on most SAS7BDAT files, whether uncompressed or using CHAR or BINARY compression. It should only be used on 'clean' datasets, by which I mean datasets that are the immediate output of a data step or PROC. Using DsShell on other datasets, for example datasets that have been edited using FSEDIT or similar, might lead to strange effects like deleted observations being output.

Note that DsShell will happily work on datasets that have a READ password. The password protection in SAS7BDAT files does NOT encrypt the data and DsShell doesn't even check to see whether a password has been set. You should not rely on a READ password to protect your data - use the ENCRYPT option for that. See SAS's rather cryptic warning about this here.

Before attempting to read a dataset, DsShell checks its 'data requirements' information. If this isn't recognised, DsShell will stop with an 'Unknown data requirements' error. If you have a data set that triggers this error, please let me know () so that DsShell can be tested against it.

Formats: DsShell ignores most formats and displays the underlying numeric and character values. The exceptions are DATE, DATETIME, YYMMDDx and TIME, for which values will be converted appropriately, though note that the length specified for the format will be ignored - that is, any DATEn. format will be output in the same format, whether it's DATE9., DATE12. etc.

Compression: DsShell can read datasets compressed with CHAR or BINARY compression.

Change History

Version 2.2: (2014-12-12)

  • Fixed more preview handler stability issues on Windows 7.

Version 2.1: (2014-12-03)

  • Fixed preview handler stability issues on Windows 7.
  • Fixed registration code detection.

Version 2.0: (2014-11-14)

  • Preview and property handlers added.
  • Windows XP no longer supported.
  • Greater range of file formats handled.
  • Speed and stability improvements.

Version 1.4: (2014-01-08)

  • Added support for the YYMMDDx formats.
  • Added support for BINARY compression.
  • Greatly improved crash-resistance and error reporting when an unreadable dataset is encountered.

Version 1.3: (there was no version 1.3)

Version 1.2: (2013-03-13)

  • Adds a new supported platform.
  • Now available in both 32-bit and 64-bit versions. As DsShell is a Windows Explorer shell extenstion, it's important that you install the version that matches Windows on your system - if you have 64-bit Windows, you need the 64-bit version of DsShell.

Version 1.1: (2012-11-16)

  • Fixes a bug when converting wide datasets (those with over around 250 variables).

Version 1.0: (2012-07-12)

  • Datasets from most 32-bit and 64-bit operating systems now supported, including Windows, Linux and Solaris.

Version 0.1:

  • Initial release.

Comments