• Print |
• E-mail  |
• Bookmark

You may receive the following error when you attempt to enter a
formatted data value that contains embedded blanks in table-view mode of
the VIEWTABLE window or in a Data Table object in a SAS/AF FRAME entry,

   ERROR:  Invalid data was entered.  Please specify another value.

Even though there is an informat associated to the column, the value you
enter is not interpreted correctly.

To circumvent the problem, use form-view mode of the VIEWTABLE window, a
data form object in a SAS/AF FRAME entry, or the FSEDIT window to enter
these data values.

To display your data set in form-view mode of the VIEWTABLE window, you
can either specify the VIEW=FORM option on the VIEWTABLE command as
follows,

   vt mylib.mydata view=form

or you can select View -> Form View from the action bar at the top of
the VIEWTABLE window to switch from table-view mode to form-view mode.

If you use the FSEDIT window, you will need to turn on the NOAUTOBLANK
attribute for that field.  To set the NOAUTOBLANK attribute, issue the
MODIFY command, select option 4 from the Modify menu, scroll to the
NOAUTOBLANK attribute, and specify "N" in the field.

Another way to circumvent this problem would be to use a format and
informat that does not include embedded blanks in the formatted- and
informatted-value strings

Operating System and Release Information