topic Re: View unformatted valus in SEG Data View in SAS Enterprise Guide

View unformatted values in SEG Data View

Haris — Tue, 07 Apr 2020 15:26:20 GMT

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.

Re: View unformatted valus in SEG Data View

Kurt_Bremser — Tue, 07 Apr 2020 14:12:38 GMT

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;

Re: View unformatted valus in SEG Data View

Haris — Tue, 07 Apr 2020 15:16:42 GMT

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.

Re: View unformatted valus in SEG Data View

Kurt_Bremser — Tue, 07 Apr 2020 15:43:20 GMT

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

Re: View unformatted valus in SEG Data View

Haris — Tue, 07 Apr 2020 16:13:38 GMT

Done!