User:Audi/BlogEntry: 2007 June 10 03:32:11 EDT

From sasCommunity

[edit] New and improved! sas2themax's Data Editor

[NOTE: When saving Excel/CSV files as SAS dataset (*.sas7bdat), variables of type "Character" (string) may be truncated because the proper length is not set correctly by the user. A dialog will be added to remind the user to check the FORMAT length of each character variable under the Column Attributes dialog.

[Update4: Version 1.0.0.39 has been uploaded. When there are several tabs (files) open in the Data Editor, a problem occurs when switching tabs after performing a data filter operation. This problem has been fixed!]

[Update3: Version 1.0.0.38 has been uploaded. Column names (variables) now conform to SAS naming rules when saving Excel/CSV files as SAS dataset; type conversions (eg. character-to-numeric, character-to-datetime) now work properly when there are missing values.]

[Update2: Version 1.0.0.37 has just been uploaded. New features include spreadsheet-like row numbering, recent documents list for data files, improved character-to-numeric type conversion, persisted column widths when changing tabs in the Data Editor, save prompt when exiting application, and more. Also fixed a few bugs/issues.]

[Update1: Version 1.0.0.35 has just been uploaded. It fixed (among other things) a problem when saving SAS datasets containing formatted numeric columns, and a bug in the character-to-numeric conversion algorithm. Also added a "$TITLECASE" custom character format.

Try this task: Open a multi-sheet Excel workbook. Save each sheet as a SAS dataset!

Latest blog: sas2themax's New Data Editor tackles SAS DATA Step chores...Read more...