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
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
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
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.