View unformatted values in SEG Data View

[Haris]

I must be going blind: I can't find a way to turn off formats in SEG data view.  Similar to the option to view variable names versus labels, can I toggle between formatted and unformatted display? I am looking at a list of 30 formatted numbers and want to use the WHERE filter in the data viewer but, to do that, I need to know the underlying number not the formatted name.

I am using SEG 7.1 in case that matters.

[Kurt_Bremser]

AFAIK, the SAS Viewtable windows always show the formatted values. But it is not so hard to define a format-less view:

proc format;
value $sex
  "F" = "Female"
  "M" = "Male"
;
run;

data class;
set sashelp.class;
format sex $sex.;
run;

data class2/view=class2;
set class;
format _all_;
run;

[Haris]

Thanks Kurt. A view is a possibility. If you enter the data-edit mode in the data viewer and double-click on any cell, the value under the format shows up too. It's just a bit of a pain to do that in many cases. In my example, I suspected that the items are not sorted in ascending order of the underlying values. That required me to click on each of the 30 cells or resort to other tricks. It would be nice if SAS included a simple toggle switch to turn formats on and off as needed.

[Kurt_Bremser]

It is surely a good reason for a SAS Software Ballot idea.

[Haris]

Done!