Last Updated on November 23, 2012
DataFerrett version 1.6.1
Users can click on a RESET button in the Advanced SQL Window which removes all user defined edits or modifications to an SQL statement and resets the original DataFerrett defined SQL statement.
For variables with MOEs as attributes, the Multi-Variable Datastep feature has been disabled. Presently, this is only applicable to the ACS 5-year Summary File datasets.
Users can append a wild card, i.e. "*",to a search term being typed in the search bar and have results returned that contain any and all words containing the search letters. For example, typing in "empl*" will return anything with either employee(s) or employer(s) in the label.
Users now have an option of using one click to quickly add all variables from a table to the data basket without having to click on "Browse/Select Variables" when using the ACS 5-year Summary File and the 2000 Decennial Summary File 1 and Summary File 3 datasets.
Users now have an option of choosing to add the geocode values in a new column if a table includes geographic areas. This option is found under the "View" menu option, and then selecting "View Geography Codes." You have a choice of seeing the "Codes Only" OR a "Fully Qualified Version." "Codes Only" returns pipe-delimited code numbers, i.e. "50|01|001", while "Fully Qualified Version" returns the individual variable names along with the code values, i.e. "SUMLEVEL=50|ST=01|COUNTY=001."
When viewing variables from a single ACS 5-year Summary File table, variables are displayed with indentations showing the detailed table structure for easier viewing as opposed to the previously flattened presentation as "fully qualified" using exclamation points to distinguish the structure.
A new geography selection window has replaced the old version. Geography selection is now based on desired level of geography and actual selection is performed by dragging and dropping selection(s) into selection window. Please refer to the new Users' Guide Chapter on using the new interface for complete details (in PDF).
In the Map Viewer, users can now customize map color themes by clicking on each color displayed in the legend and selecting a new shade or color.
In the Graph Viewer, a user can now customize a graph by selecting desired colors for each element of a graph.
When dropping a variable in the first column/row of a table (C1,R2), a second variable in the first available column (C2), and highlighting the label column (C1) and selecting "Sort", the labels in the column (C1) no longer disappear.
Explanation: Prior to this fix, the row labels would temporarily disappear when sorting on the first column of a table (column 1 containing the row labels) until "Go Get Data" was selected.
When using a user-defined computed variable in a spreadsheet to create a newly defined computed variable in the same spreadsheet, DataFerrett no longer crashes.
Explanation: Prior to this fix, a user could not create a computed variable in a spreadsheet and then use that same variable for a new computation, as this action caused DataFerrett to crash.
The merge function could be inconsistent when merging two datasets based on geography, resulting in no data retrieval.
Explanation: Prior to this fix, when attempting to merge two datasets based on geography, the merge did not always function properly and no data was returned after selecting "Go Get Data".
Due to server issues, occasionally a datafile was not attached to the HTML link returned in the email to a user when requesting a batch extraction.
When selecting a pre-composed statistical table under the "Examples" link on the Introduction page of DataFerrett, after selecting a sample table, the "Go Get Data" button is disabled, as this step is not necessary, the data will be returned automatically.
Explanation:: Prior to this fix, when a user clicked on "Go Get Data" before the example table finished populating the selected data, the DataFerrett application would freeze and the user was required to close out completely and restart the DataFerrett session.