Special missing in Entreprise Guide

Classe1 — Wed, 10 Apr 2019 08:33:26 GMT

Hello!

New Sas-user here 🙂

When I have a special missing value (.A, .N, .E…) in the datagrid in EG and want to view the unformatted value, I enter edit mode by double cklicking the cell.
The value then shows as a regular missing . (dot). If I leave the edit mode then the dot seems to be saved instead of the .A it was before… Why?

Thanks

Re: Special missing in Entreprise Guide

andypandy_swe — Wed, 10 Apr 2019 08:34:44 GMT

I got the following response from a SAS representative a while back when I noticed the same problem:

The EG data grid does not currently support setting special missing values. I will add this as a requirement to the EG data grid, since it should handle this better (and as you experienced, can too easily result in a data integrity issue).

In the meantime, if you wish to simply view a raw value, press the Esc key (rather than the Enter key or clicking elsewhere) when you wish to leave edit mode for a cell, so the value is not committed back to the source

topic Special missing in Entreprise Guide in SAS Enterprise Guide

Special missing in Entreprise Guide

Re: Special missing in Entreprise Guide