Documentation

Table of Contents

• Tutorial
• How-to Guide
• Shortcut Keys

Tutorial

This is a step by step tutorial to show you the main features of StatDataViewer. There is also a screenshot of each step for your reference. Let’s assume that StatDataViewer is in the folder c:/StatDataViewer/.

1. Open StatDataViewer.exe

2. Open a SAS dataset c:/StatDataViewer/Docs/Samples/SDTM/dm.sas7bdat

3. Set an alias “DemoSDTM” for the library c:/StatDataViewer/Docs/Samples/SDTM/

3.1 Right click on “c:\StatDataViewer\Docs\Samples\SDTM\” and then click “Set Libname”

3.2 Type in the libname “DemoSDTM”, and click “OK” button.

4. Click the “Auto Hide” button of the Workspace window

5. Move the mouse cursor on the tab “Variables - dm” on the right side and hover.

6. Dock the Variables window

6.1 Click the “Auto Hide” button of the Variables window

6.2 You can see the Variables window is docked.

7. Click any cell of the Dataset window and make the Dataset window get focus

8. Right click on any cell of the column USUBJID and click “Hide Variable”

9. Click any cell of the Variables window and make the Variables window get focus

10. Click the checkbox on the row USUBJID

11. Let’s Hide All Variables

11.1 Right click on any cell of the Variables window, and click “Hide All Variables”

11.2 You will see that all the variables are hidden.

12. Click the checkbox to show the variables USUBJID, AGE, SEX, and ARM

13. Click any cell of the Dataset window and make the Dataset window get focus

14. Let’s calculate the Frequency of SEX by context menu

14.1 Right click any cell of the column SEX, and click “Frequency”

14.2 Now you will see the frequencies of SEX on right side Frequency window.

15. Let’s calculate the Frequency of ARM by shortcut key ‘F’

15.1 Click any cell of the column ARM, and press the key ‘F’ on the keyboard

15.2 Now you will see the frequencies of ARM on right side Frequency window.

16. Crosstabulation

16.1 Hold Ctrl key, click any cell of the column SEX, then click any cell of the column ARM

16.2 press the key ‘F’ on the keyboard

17. Let’s open another SAS dataset

17.1 Click “Workspace” on the left side

17.2 Double click “ae.sas7bdat”

18. Click any cell of the Dataset window with the title “ae.sas7bdat” and make it get focus

19. Let’s calculate the “Frequency(USUBJID)” of USUBJID

19.1 Right click any cell of the column USUBJID and click “Frequency(USUBJID)”

19.2 Now you will see the count of distict USUBJID of USUBJID on right side Frequency window.

20. Try again to right click any cell of the column STUDYID and click “Frequency(USUBJID)”

21. Let’s try the Find feature

21.1 Press shortcut key “Ctrl + F”, enter “Vomiting” in the Find ComboBox and press “Enter” key

21.2 Press “F3” to find next one, and you will find that the Find feature is case insensitive.

22. Let’s try to enter the filter manually

22.1 Click the Command ComboBox

22.2 Enter “if aeseq = 3”, and press “Enter” key

22.3 Press the shortcut key “C” to clear the dataset filter, and you will see “clear dataset filter” in the Command ComboBox

22.4 Press the shortcut key “F5” to focus Command ComboBox, then enter “if aestdy > aeendy”

How-to Guide

How to subset a single dataset?

• Right click on the variable’s value to be used in the IF clause.
• Choose from the IF clauses listed in the context menu.
• Repeat the above steps below if you need to add another subset condition.

Shortcut Key: D.

D stands for Dataset filter, and the default operator is ‘=’.

Reter to Shortcut Keys for other shortcut keys. For example, the ‘<’ key will filter for all values less than the value you are on.

How to Clear the dataset filter?

Right click anywhere on the data and choose “Clear Dataset Filter” from the context menu.

Shortcut Key: C.

C stands for Clear dataset filter.

How to undo the Dataset Filter?

If you are using the shortcut keys to filter the data, you can use shortcut key “Z” or “Ctrl + Z” to undo one step.

Shortcut Key: Z or Ctrl + Z.

C stands for Clear dataset filter.

How to know the current dataset filter?

• The complete dataset filter text is shown in the Status Bar at the bottom of the screen. If the dataset filter text is truncated, you can hover the mouse cursor over it, a tip box will show all the text.
• Or you can also click the filter icon on the toolbar, a dialog window “Dataset Filter” will show the complete dataset filter text.

How to change the default logical operator from AND to OR while subsetting?

Compound dataset subsets are built with the default logical operator AND. If you want to use the logical operator OR, please type in the shortcut key ‘(‘ to start, then all the subset conditions are linked with OR until you type in ‘)’.

How to Subset on all the datasets in a library?

• Right click on the variable’s value to be used in the WHERE clause.
• Choose the WHERE clause from the context menu.

Tip:

• You can only define one condition for the library filter.
• Use caution with the Library filter. You may unknowingly be looking at a filtered dataset. If you aren't seeing what you expected, check for a Library filter in the Status Bar.

Shortcut Key: L.

L stands for Library filter.

How to know the current library filter?

The library filter is shown in the Status Bar at the bottom of the screen in red color.

How to Clear the library filter?

Right click anywhere on the data and choose “Clear Library Filter” from the context menu.

Shortcut Key: ALT + C.

C stands for Clear library filter.

How to get frequencies of values of one variable?

From anywhere within that variable’s column, right click and choose “Frequency” from the context menu.

Tip:

• The Frequency window will open and show the values of that variable in descending order of frequency.
• Clicking on the 'Frequency' header in that window will switch the order to ascending.
• Clicking on the 'Value' header will display the values in alphabetical order.

Shortcut Key: F.

F stands for Frequency.

How to get frequencies of values of multiple variables (crosstabulation)?

• Holding Ctrl to select multiple cells. One varialbe, one cell.
• Right click on one of the selected cells
• Choose “Frequency” from the context menu

Tip:

• You can also use the shortcut key F instead of context menus.

How to get frequencies of distinct USUBJIDs of one variable?

From anywhere within that variable’s column, right click and choose “Frequency (USUBJID)” from the context menu.

Shortcut Key: N.

N is the Number of distinct USUBJIDs.

How to get frequencies of distinct USUBJIDs of multiple variables (crosstabulation)?

• Holding Ctrl to select multiple cells. One varialbe, one cell.
• Right click on one of the selected cells
• Choose “Frequency (USUBJID)” from the context menu

How to use the Frequency window to help with subsetting?

From within the Frequency window, right click and choose the appropriate filter.

Tip: if there are more than a few values, you may want to sort the frequency window by the Values to be able to quickly find the value you want to subset.

How to Hide/Unhide variables from the Variables window?

• Uncheck and check the CheckBox of variables to hide and unhide variables respectively.
• Or right click on the row/variable and choose “Hide/Unhide Variable” from the context menu.

Shortcut Key: H.

H stands for Hide variable.

How to Hide variables from the Dataset window?

• Select one cell of the column/variable that you want to hide
• Right click and choose “Hide Variable” from the context menu

Shortcut Key: H.

H stands for Hide variable.

How to Hide all variables from the Variables window?

Right click any cell and choose “Hide All Variables” from the context menu.

Shortcut Key: ALT + H.

H stands for Hide variable.

How to Unhide all variables from the Variables window?

Right click any cell and choose “Unhide All Variables” from the context menu.

Shortcut Key: U.

U stands for Unhide all variables.

How to Unhide all variables from the Dataset window?

Right click any cell and choose “Unhide Variables” from the context menu.

Shortcut Key: U.

U stands for Unhide variables.

How to Sort variable list?

If there is no CheckBox column in the Variables window, you can sort the variables list. The Variables window will show the columns in the order they appear in the dataset. You can re-sort the variables list by any of the attributes shown by clicking on the header, but the variables will remain in the defined order in the dataset itself.

How to Go to a variable quickly from the Variables window?

Once you’ve located the variable you want in the Variables list, right click on it and choose “Go to Variable” from the context menu.

Shortcut Key: G.

G stands for Go to variable.

How to look up a variable’s metadata from the Dataset window?

Once you’ve located the variable in the Dataset window, use the shortcut key G or V to show this variable’s metadata in the Variables window.

Shortcut Key: G or V.

G stands for Go to variable metadata; V stands for Variable window.

How to Reorder the variables from the Variables window?

Shift Variable Up

Right click on the row/variable and choose “Shift Variable Up”, then the variable in the Variables window will shift up, and the variable in the Dataset window will shift left.

Shortcut Key: ALT + Up.

Shift Variable Down

Right click on the row/variable and choose “Shift Variable Down”, then the variable in the Variables window will shift down, and the variable in the Dataset window will shift right.

Shortcut Key: ALT + Down.

How to Reorder the variables from the Dataset window?

Shift Variable Left

Right click on the column/variable and choose “Shift Variable Left”, then the variable in the Dataset window will shift left, and the variable in the Variables window will shift up.

Shortcut Key: ALT + Left.

Shift Variable Right

Right click on the column/variable and choose “Shift Variable Right”, then the variable in the Dataset window will shift right, and the variable in the Variables window will shift up.

Shortcut Key: ALT + Right.

How to show a specific window?

If one of the docking windows you are looking for is not visible, choose View > Toolbars and Docking Windows > window from the ribbon. Available windows are: Workspace, Variables, Shortcut Keys and Frequency.

How to show the Variables window quickly?

Use the shortcut key V.

Shortcut Key: V.

V stands for Variable window.

How to dock and float a specific window?

Once opened, you can toggle between docked/pinned and floating by double clicking on the window’s title bar. Docked windows can be pinned to remain open or unpinned to automatically hide when you click outside of them. You can dock a window to any of the four edges of the main application window by dragging it to the edge where you want it to be.

Tip: send a floating window off-screen to another monitor if you are using an extended desktop.

Tip: resize windows by grabbing a side and dragging it.

How to view one dataset in two separated tabs?

Datasets maybe viewed as tabs in a single window or may be separated into individual tabs. To separate them, grab the tab and move it till the page icon appears, then drag it down into the body of the dataset window. To move them back together into a single window, grab and drag it back to the dataset window of your choice.

How to add a Library to the Workspace?

Click on the ‘Open’ icon at the top left corner of the screen in the Standard menu, or use the keyboard shortcut CTRL+O, and then navigate to the library of your choice. Open a dataset. The entire library will now be available through the Workspace tab in StatDataViewer.

Tip: If you already have the folder open in Windows Explorer, just copy and paste the address into the Open window.

Tip: Can’t find the ‘Open’ icon? Make sure the Standard toolbar is being displayed. Choose ‘View> Toolbars and Docking Windows > Standard’ from the Ribbon menu

How to remove a Library from the Workspace?

From the Workspace tab, right click on the library to be removed, and choose ‘Remove’ from the context menu.

How to Refresh a Library in the Workspace?

From the Workspace tab, right click on the library to be refreshed, and choose ‘Refresh’ from the context menu.

How to Open a dataset?

Once you’ve registered a Library in the Workspace, you can simply double click on a dataset to open it.

How to Set libname for a library?

• Right click on the library
• Choose “Set Libname” and a dialog window “StatDataViewer - Library Alias” will show
• Enter the library name and click OK button

How to remove libname for a library?

• Right click on the library
• Choose “Set Libname” and a dialog window “StatDataViewer - Library Alias” will show
• Delete the library name and click OK button

How to Watch File Changes?

Right click on the library, then choose “Watch File Changes”. Now you will find that this library will refresh automatically to reflect all the file changes of that folder.

How to Open New Dataset Automatically?

While Watch File Changes is on, right click on the library, then choose “Open New Dataset Automatically”. Now you will see the new created SAS datasets in this library will be opened by StatDataViewer automatically.

How to View Dataset Variables like SAS Universal Viewer?

• Right click on the library, then choose “View Dataset Variables” to toggle this feature on.
• Click on a dataset in this library, the Variables window will show this dataset’s variables metadata.

How to enter the Library filter manually?

Press the shortcut key “F5” to focus the Command ComboBox, then you can enter the filter condition there, such as where usubjid = “CDISC01.100014”.

Shortcut Key: F5.

How to enter the Dataset filter manually?

Press the shortcut key “F5” to focus the Command ComboBox, then you can enter the filter condition there, such as if age = 66 and sex = “F”

Shortcut Key: F5.

How to find?

• Click the Find ComboBox
• Type in the keyword, such as “white”
• Press Enter key or click the Find button on the right.

Shortcut Key: Ctrl + F or Alt + S.

F stands for Find; S stands for Search.

How to find next?

Use the shortcut key F3 or S.

Shortcut Key: F3 or S.

F3 is used by many applications; S stands for Search.

How to find previous?

Use the shortcut key Shift + F3 or R.

Shortcut Key: Shift + F3 or R.

Shift + F3 is used by many applications; R stands for Reverse search.

How to quickly locate a variable by finding the variable name?

If the feature “Locate the variable by searching variable name” is on, you can type in the variable name in the Find ComboBox to locate the variable in the dataset window quickly.

How to set a different font(name, size, etc) for the dataset window?

• Click Edit -> Options
• Click “Font” button from the dialog window “StatDataViewer Options”

How to increase the font size quickly?

Use the shortcut key Ctrl + +.

Shortcut Key: Ctrl + +.

• stands for increase the font size.

How to decrease the font size quickly?

Use the shortcut key Ctrl + -.

Shortcut Key: Ctrl + -.

• stands for decrease the font size.

Shortcut Keys

Use the Shortcut Keys window to show the list of shortcut keys

Dataset Window

Action	Shortcut Keys	Description
Find Next	S; F3	Find next.
Find Previous	R; Shift + F3	Find Previous.
Dataset Filter, In operator	I	Filter data with operator ‘in’.
Dataset Filter, Equal	D; =	Filter data with operator =.
Dataset Filter, Uneuqal	^; ~	Filter data with operator ^= or ~=.
Dataset Filter, Greater	>	Filter data with operator >.
Dataset Filter, Less	<	Filter data with operator <.
Dataset Filter, Greater or Equal	Alt + >	Filter data with operator >=.
Dataset Filter, Less or Equal	Alt + <	Filter data with operator <=.
Dataset Filter, Undo	Z; Ctrl+Z	Undo one step of dataset filter.
Dataset Filter, Start OR	(	The logical operator changes to OR.
Dataset Filter, End OR	)	End the OR logical expression, and the logical operator changes to AND.
Clear Dataset Filter	C	Clear dataset level filter.
Library Filter	L	Filter data with operator =. It is library level.
Clear Library Filter	Alt+C	Clear library level filter.
Apply Library Filter	Alt+L	Apply library level filter.
Frequency	F	Get the frequency of the selected variable(s). Select multiple variables by holding down the Ctrl key.
Freq (USUBJID)	N	Count distinct USUBJID of the selected variable(s). Select multiple variables by holding down the Ctrl key.
Hide Variable	H	Hide the focused variable.
Hide All Variables	ALT + H	Hide all the variables.
Unhide All Variables	U	Unhide all hidden variables.
Shift Variable Left	ALT + Left	Move the focused variable to the left.
Shift Variable Right	ALT + Right	Move the focused variable to the right.
Go to Variable	G; V	Jump to the focused variable in Variables Window.
Close Dataset	W; Ctrl + W	Close the current dataset
Close All Datasets	Ctrl + Shift + W	Close all the opened datasets
Go to Observation	Ctrl + G	Go to any observation no you entered.
Increase the Font Size	Ctrl + +	Make the font bigger.
Decrease the Font Size	Ctrl + -	Make the font smaller.

Frequency Window

Action	Shortcut Keys	Description
Dataset Filter, In operator	I	Filter data with operator ‘in’.
Dataset Filter, Equal	D; =	Filter data with operator =.
Clear Dataset Filter	C	Clear dataset level filter.
Library Filter	L	Filter data with operator =. It is library level.
Clear Library Filter	Alt+C	Clear library level filter.

Variables Window

Action	Shortcut Keys	Description
Hide Variable	H	Hide the focused variable.
Hide All Variables	ALT + H	Hide all the variables.
Unhide All Variables	U	Unhide all hidden variables.
Shift Variable Left	ALT + Up	Move the focused variable to the left.
Shift Variable Right	ALT + Down	Move the focused variable to the right.
Go to Variable	G	Jump to the focused variable in Dataset Window.

Workspace Window

Action	Shortcut Keys	Description
Open Dataset	Enter	Open the dataset selected.